PREVIEW / etf_30min / 2014-06-19

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-19.parquet
  size:    341 KB
  rows:    11,661

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
2014-06-19 04:00:00	SPY	ETF	196.36	196.36	196.31	196.31	1053.0
2014-06-19 04:30:00	SPY	ETF	196.31	196.31	196.31	196.31	267.0
2014-06-19 05:00:00	SPY	ETF	196.53	196.53	196.53	196.53	1000.0
2014-06-19 05:30:00	SPY	ETF	196.38	196.38	196.28	196.36	1300.0
2014-06-19 06:00:00	SPY	ETF	196.36	196.38	196.36	196.38	3710.0
2014-06-19 06:30:00	SPY	ETF	196.32	196.32	196.24	196.27	1250.0
2014-06-19 07:00:00	SPY	ETF	196.3	196.33	196.26	196.31	7275.0
2014-06-19 07:30:00	SPY	ETF	196.28	196.31	196.24	196.28	36599.0
2014-06-19 08:00:00	SPY	ETF	196.28	196.48	196.26	196.4	242065.0
2014-06-19 08:30:00	SPY	ETF	196.44	196.46	196.38	196.4	317554.0
2014-06-19 09:00:00	SPY	ETF	196.4	196.49	196.4	196.43	316838.0
2014-06-19 09:30:00	SPY	ETF	196.43	196.6	196.275	196.32	8090031.0
2014-06-19 10:00:00	SPY	ETF	196.33	196.46	196.122	196.275	6598905.0
2014-06-19 10:30:00	SPY	ETF	196.27	196.41	196.04	196.06	5057651.0
2014-06-19 11:00:00	SPY	ETF	196.05	196.2	195.99	196.09	5878540.0
2014-06-19 11:30:00	SPY	ETF	196.08	196.21	196.06	196.165	7089554.0
2014-06-19 12:00:00	SPY	ETF	196.17	196.25	196.07	196.09	2698504.0
2014-06-19 12:30:00	SPY	ETF	196.09	196.21	195.99	196.02	3170726.0
2014-06-19 13:00:00	SPY	ETF	196.03	196.07	195.8	196.03	6424588.0
2014-06-19 13:30:00	SPY	ETF	196.03	196.15	195.94	196.1	4582858.0
2014-06-19 14:00:00	SPY	ETF	196.11	196.28	196.05	196.17	5000843.0
2014-06-19 14:30:00	SPY	ETF	196.175	196.28	196.08	196.25	3067186.0
2014-06-19 15:00:00	SPY	ETF	196.25	196.44	196.23	196.3999	6129275.0
2014-06-19 15:30:00	SPY	ETF	196.4	196.54	196.36	196.49	11590926.0
2014-06-19 16:00:00	SPY	ETF	196.5	196.5378	196.38	196.45	5794304.0
2014-06-19 16:30:00	SPY	ETF	196.44	196.45	196.35	196.37	3259168.0
2014-06-19 17:00:00	SPY	ETF	196.37	196.38	196.3	196.3	93222.0
2014-06-19 17:30:00	SPY	ETF	196.33	196.36	196.33	196.35	10940.0
2014-06-19 18:00:00	SPY	ETF	196.35	196.37	196.31	196.35	67678.0
2014-06-19 18:30:00	SPY	ETF	196.33	196.36	196.32	196.32	9300.0
2014-06-19 19:00:00	SPY	ETF	196.33	196.34	196.31	196.32	11965.0
2014-06-19 19:30:00	SPY	ETF	196.32	196.35	196.31	196.31	7745.0
2014-06-19 04:00:00	QQQ	ETF	92.93	92.93	92.93	92.93	100.0
2014-06-19 08:00:00	QQQ	ETF	93.05	93.07	93.02	93.05	78622.0
2014-06-19 08:30:00	QQQ	ETF	93.08	93.11	93.05	93.09	92402.0
2014-06-19 09:00:00	QQQ	ETF	93.09	93.12	93.09	93.1	174200.0
2014-06-19 09:30:00	QQQ	ETF	93.1	93.17	92.905	92.931	2618607.0
2014-06-19 10:00:00	QQQ	ETF	92.94	93.08	92.86	92.97	1729705.0
2014-06-19 10:30:00	QQQ	ETF	92.97	93.02	92.73	92.77	1940183.0
2014-06-19 11:00:00	QQQ	ETF	92.77	92.847	92.75	92.8	1256477.0
2014-06-19 11:30:00	QQQ	ETF	92.8	92.86	92.75	92.79	520978.0
2014-06-19 12:00:00	QQQ	ETF	92.8	92.89	92.76	92.78	580377.0
2014-06-19 12:30:00	QQQ	ETF	92.79	92.83	92.605	92.625	1041254.0
2014-06-19 13:00:00	QQQ	ETF	92.6201	92.68	92.49	92.591	1322561.0
2014-06-19 13:30:00	QQQ	ETF	92.59	92.66	92.53	92.62	1518943.0
2014-06-19 14:00:00	QQQ	ETF	92.625	92.77	92.58	92.71	839367.0
2014-06-19 14:30:00	QQQ	ETF	92.71	92.825	92.66	92.79	1129727.0
2014-06-19 15:00:00	QQQ	ETF	92.8	92.89	92.79	92.89	1028593.0
2014-06-19 15:30:00	QQQ	ETF	92.885	92.94	92.84	92.91	2908966.0
2014-06-19 16:00:00	QQQ	ETF	92.92	93.0221	92.82	92.87	6892176.0

> showing 50 of 11,661 rows — these rows as CSV

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