PREVIEW / etf_30min / 2013-08-06

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-06.parquet
  size:    316 KB
  rows:    10,710

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2013-08-06 04:00:00	SPY	ETF	170.68	170.71	170.68	170.68	1370.0
2013-08-06 04:30:00	SPY	ETF	170.65	170.71	170.65	170.69	700.0
2013-08-06 05:00:00	SPY	ETF	170.71	170.83	170.71	170.8	1200.0
2013-08-06 05:30:00	SPY	ETF	170.77	170.77	170.65	170.65	3000.0
2013-08-06 06:00:00	SPY	ETF	170.63	170.63	170.43	170.47	7800.0
2013-08-06 06:30:00	SPY	ETF	170.44	170.47	170.41	170.44	1600.0
2013-08-06 07:00:00	SPY	ETF	170.41	170.48	170.35	170.45	21400.0
2013-08-06 07:30:00	SPY	ETF	170.47	170.5	170.44	170.44	40750.0
2013-08-06 08:00:00	SPY	ETF	170.45	170.48	170.37	170.48	78686.0
2013-08-06 08:30:00	SPY	ETF	170.47	170.56	170.42	170.45	321700.0
2013-08-06 09:00:00	SPY	ETF	170.47	170.48	170.29	170.36	359332.0
2013-08-06 09:30:00	SPY	ETF	170.37	170.52	170.02	170.19	11750665.0
2013-08-06 10:00:00	SPY	ETF	170.18	170.2	169.85	169.88	9027805.0
2013-08-06 10:30:00	SPY	ETF	169.89	169.895	169.41	169.41	10795248.0
2013-08-06 11:00:00	SPY	ETF	169.41	169.77	169.35	169.73	5935742.0
2013-08-06 11:30:00	SPY	ETF	169.73	169.81	169.68	169.77	3981064.0
2013-08-06 12:00:00	SPY	ETF	169.77	170.7402	169.61	169.69	3394751.0
2013-08-06 12:30:00	SPY	ETF	169.69	169.96	169.69	169.95	2395781.0
2013-08-06 13:00:00	SPY	ETF	169.94	169.97	169.88	169.92	1822720.0
2013-08-06 13:30:00	SPY	ETF	169.92	169.94	169.69	169.721	3048115.0
2013-08-06 14:00:00	SPY	ETF	169.73	169.85	169.565	169.79	3091603.0
2013-08-06 14:30:00	SPY	ETF	169.79	169.84	169.62	169.74	2303286.0
2013-08-06 15:00:00	SPY	ETF	169.75	169.84	169.7	169.81	3530433.0
2013-08-06 15:30:00	SPY	ETF	169.81	169.99	169.65	169.75	10473216.0
2013-08-06 16:00:00	SPY	ETF	169.76	170.2712	169.5011	169.86	5027460.0
2013-08-06 16:30:00	SPY	ETF	169.86	169.86	169.766	169.81	7604791.0
2013-08-06 17:00:00	SPY	ETF	169.8	169.8	169.73	169.77	85413.0
2013-08-06 17:30:00	SPY	ETF	169.77	169.8	169.75	169.77	56666.0
2013-08-06 18:00:00	SPY	ETF	169.77	169.84	169.69	169.73	62200.0
2013-08-06 18:30:00	SPY	ETF	169.71	169.73	169.69	169.7	25600.0
2013-08-06 19:00:00	SPY	ETF	169.72	169.72	169.65	169.65	16834.0
2013-08-06 19:30:00	SPY	ETF	169.64	169.7	169.62	169.69	13445.0
2013-08-06 04:00:00	QQQ	ETF	77.02	77.04	77.02	77.02	6200.0
2013-08-06 05:00:00	QQQ	ETF	77.04	77.06	77.04	77.06	1100.0
2013-08-06 05:30:00	QQQ	ETF	77.04	77.04	76.98	76.98	3300.0
2013-08-06 06:00:00	QQQ	ETF	76.96	76.96	76.92	76.92	3000.0
2013-08-06 06:30:00	QQQ	ETF	76.94	76.94	76.94	76.94	1000.0
2013-08-06 07:00:00	QQQ	ETF	76.92	76.94	76.92	76.94	1000.0
2013-08-06 07:30:00	QQQ	ETF	76.94	76.96	76.94	76.94	13815.0
2013-08-06 08:00:00	QQQ	ETF	76.92	76.94	76.91	76.94	11700.0
2013-08-06 08:30:00	QQQ	ETF	76.96	77.01	76.79	76.96	40100.0
2013-08-06 09:00:00	QQQ	ETF	76.94	76.96	76.88	76.92	39342.0
2013-08-06 09:30:00	QQQ	ETF	76.92	76.99	76.71	76.8099	1807473.0
2013-08-06 10:00:00	QQQ	ETF	76.81	76.82	76.64	76.64	1909705.0
2013-08-06 10:30:00	QQQ	ETF	76.65	76.65	76.2901	76.2901	1718104.0
2013-08-06 11:00:00	QQQ	ETF	76.29	76.51	76.25	76.489	1431179.0
2013-08-06 11:30:00	QQQ	ETF	76.495	76.53	76.47	76.52	501681.0
2013-08-06 12:00:00	QQQ	ETF	76.51	76.58	76.49	76.509	616046.0
2013-08-06 12:30:00	QQQ	ETF	76.51	76.64	76.5	76.63	392918.0
2013-08-06 13:00:00	QQQ	ETF	76.63	76.63	76.57	76.59	489932.0

> showing 50 of 10,710 rows — these rows as CSV

> unlock the full archive -- $79 one-time