PREVIEW / etf_30min / 2011-06-27

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-27.parquet
  size:    277 KB
  rows:    9,204

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
2011-06-27 04:00:00	SPY	ETF	126.86	126.9	126.69	126.9	7900.0
2011-06-27 04:30:00	SPY	ETF	126.97	127.2	126.97	127.2	3950.0
2011-06-27 05:00:00	SPY	ETF	127.2	127.26	127.15	127.15	5972.0
2011-06-27 05:30:00	SPY	ETF	127.15	127.2	127.08	127.15	2900.0
2011-06-27 06:00:00	SPY	ETF	127.2	127.48	127.2	127.28	8450.0
2011-06-27 06:30:00	SPY	ETF	127.26	127.4	127.17	127.17	11800.0
2011-06-27 07:00:00	SPY	ETF	127.22	127.28	127.11	127.12	160270.0
2011-06-27 07:30:00	SPY	ETF	127.12	127.24	127.09	127.1	95350.0
2011-06-27 08:00:00	SPY	ETF	127.08	127.3	126.93	127.11	975401.0
2011-06-27 08:30:00	SPY	ETF	127.09	127.12	126.86	126.93	979619.0
2011-06-27 09:00:00	SPY	ETF	126.93	126.95	126.7	126.89	1438899.0
2011-06-27 09:30:00	SPY	ETF	126.89	127.37	126.64	127.18	21091013.0
2011-06-27 10:00:00	SPY	ETF	127.18	127.75	127.14	127.75	12213251.0
2011-06-27 10:30:00	SPY	ETF	127.75	127.82	127.53	127.67	11919140.0
2011-06-27 11:00:00	SPY	ETF	127.68	127.77	127.4	127.51	7728090.0
2011-06-27 11:30:00	SPY	ETF	127.51	127.87	127.45	127.86	8116050.0
2011-06-27 12:00:00	SPY	ETF	127.8501	127.95	127.71	127.82	5777204.0
2011-06-27 12:30:00	SPY	ETF	127.8	127.88	127.725	127.76	5140897.0
2011-06-27 13:00:00	SPY	ETF	127.76	127.93	127.64	127.65	7447826.0
2011-06-27 13:30:00	SPY	ETF	127.66	127.87	127.59	127.78	8290307.0
2011-06-27 14:00:00	SPY	ETF	127.775	128.33	127.775	128.29	15105836.0
2011-06-27 14:30:00	SPY	ETF	128.3	128.43	128.25	128.26	10906865.0
2011-06-27 15:00:00	SPY	ETF	128.27	128.4	128.18	128.27	6482238.0
2011-06-27 15:30:00	SPY	ETF	128.26	128.33	127.92	127.95	24346654.0
2011-06-27 16:00:00	SPY	ETF	127.95	128.17	127.53	128.16	12787866.0
2011-06-27 16:30:00	SPY	ETF	128.16	128.25	128.12	128.22	150550.0
2011-06-27 17:00:00	SPY	ETF	128.23	128.26	128.12	128.23	172699.0
2011-06-27 17:30:00	SPY	ETF	128.24	128.27	128.2	128.21	20086.0
2011-06-27 18:00:00	SPY	ETF	128.23	128.26	127.93	128.25	475099.0
2011-06-27 18:30:00	SPY	ETF	128.25	128.33	126.7679	128.26	2070476.0
2011-06-27 19:00:00	SPY	ETF	128.26	128.34	128.25	128.33	28416.0
2011-06-27 19:30:00	SPY	ETF	128.32	128.37	128.31	128.36	21532.0
2011-06-27 05:00:00	QQQ	ETF	54.44	54.5	54.44	54.5	1300.0
2011-06-27 06:00:00	QQQ	ETF	54.43	54.43	54.43	54.43	300.0
2011-06-27 06:30:00	QQQ	ETF	54.47	54.47	54.44	54.44	7200.0
2011-06-27 07:00:00	QQQ	ETF	54.45	54.47	54.41	54.41	3200.0
2011-06-27 07:30:00	QQQ	ETF	54.46	54.46	54.42	54.42	500.0
2011-06-27 08:00:00	QQQ	ETF	54.41	54.45	54.02	54.43	145667.0
2011-06-27 08:30:00	QQQ	ETF	54.42	54.42	54.32	54.34	109123.0
2011-06-27 09:00:00	QQQ	ETF	54.34	54.43	54.27	54.43	338348.0
2011-06-27 09:30:00	QQQ	ETF	54.43	54.69	54.32	54.63	7801397.0
2011-06-27 10:00:00	QQQ	ETF	54.63	55.01	54.61	55.01	4615131.0
2011-06-27 10:30:00	QQQ	ETF	55.01	55.06	54.94	54.97	3181942.0
2011-06-27 11:00:00	QQQ	ETF	54.97	55.025	54.92	54.97	2633091.0
2011-06-27 11:30:00	QQQ	ETF	54.97	55.16	54.945	55.1471	2637292.0
2011-06-27 12:00:00	QQQ	ETF	55.149	55.23	55.12	55.17	2583611.0
2011-06-27 12:30:00	QQQ	ETF	55.16	55.23	55.15	55.18	970870.0
2011-06-27 13:00:00	QQQ	ETF	55.185	55.2699	55.1	55.11	1869148.0
2011-06-27 13:30:00	QQQ	ETF	55.12	55.22	55.09	55.195	1781358.0
2011-06-27 14:00:00	QQQ	ETF	55.19	55.44	55.19	55.43	2981399.0

> showing 50 of 9,204 rows — these rows as CSV

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