PREVIEW / etf_30min / 2014-04-01

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-01.parquet
  size:    342 KB
  rows:    11,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
2014-04-01 04:00:00	SPY	ETF	187.2	187.28	187.17	187.18	2499.0
2014-04-01 04:30:00	SPY	ETF	187.25	187.25	187.24	187.24	28000.0
2014-04-01 05:00:00	SPY	ETF	187.23	187.23	187.18	187.18	2400.0
2014-04-01 05:30:00	SPY	ETF	187.2	187.25	187.2	187.22	2037.0
2014-04-01 06:00:00	SPY	ETF	187.2	187.24	187.18	187.24	5614.0
2014-04-01 06:30:00	SPY	ETF	187.27	187.49	187.27	187.47	67768.0
2014-04-01 07:00:00	SPY	ETF	187.45	187.47	187.33	187.37	144437.0
2014-04-01 07:30:00	SPY	ETF	187.37	187.46	187.36	187.46	73719.0
2014-04-01 08:00:00	SPY	ETF	187.37	187.5	187.34	187.44	222595.0
2014-04-01 08:30:00	SPY	ETF	187.44	187.48	187.38	187.4	305077.0
2014-04-01 09:00:00	SPY	ETF	187.41	187.66	187.04	187.63	912004.0
2014-04-01 09:30:00	SPY	ETF	187.62	188.0	187.53	187.96	14672731.0
2014-04-01 10:00:00	SPY	ETF	187.95	188.23	187.92	188.03	7456421.0
2014-04-01 10:30:00	SPY	ETF	188.035	188.18	187.69	187.8	6750912.0
2014-04-01 11:00:00	SPY	ETF	187.8	187.835	187.59	187.71	4596245.0
2014-04-01 11:30:00	SPY	ETF	187.7	187.89	187.58	187.6	4749485.0
2014-04-01 12:00:00	SPY	ETF	187.601	187.73	187.45	187.71	4383365.0
2014-04-01 12:30:00	SPY	ETF	187.71	187.81	187.65	187.69	2518950.0
2014-04-01 13:00:00	SPY	ETF	187.69	187.71	187.51	187.7	3971778.0
2014-04-01 13:30:00	SPY	ETF	187.708	187.88	187.6	187.86	2780752.0
2014-04-01 14:00:00	SPY	ETF	187.855	188.02	187.82	187.98	5228667.0
2014-04-01 14:30:00	SPY	ETF	187.97	188.04	187.88	188.0001	4130140.0
2014-04-01 15:00:00	SPY	ETF	188.01	188.15	187.9	188.131	3698686.0
2014-04-01 15:30:00	SPY	ETF	188.14	188.36	187.98	188.25	13086115.0
2014-04-01 16:00:00	SPY	ETF	188.25	188.38	187.0015	188.31	7138641.0
2014-04-01 16:30:00	SPY	ETF	188.3	188.36	188.25	188.34	1017999.0
2014-04-01 17:00:00	SPY	ETF	188.34	188.34	188.26	188.27	364887.0
2014-04-01 17:30:00	SPY	ETF	188.28	188.3	188.26	188.28	115499.0
2014-04-01 18:00:00	SPY	ETF	188.28	188.35	188.22	188.3	98190.0
2014-04-01 18:30:00	SPY	ETF	188.3	188.36	188.26	188.26	24598.0
2014-04-01 19:00:00	SPY	ETF	188.27	188.29	188.23	188.24	32225.0
2014-04-01 19:30:00	SPY	ETF	188.29	188.3	188.23	188.29	78805.0
2014-04-01 04:00:00	QQQ	ETF	87.72	87.72	87.72	87.72	300.0
2014-04-01 04:30:00	QQQ	ETF	87.72	87.72	87.72	87.72	6000.0
2014-04-01 05:30:00	QQQ	ETF	87.73	87.73	87.73	87.73	1000.0
2014-04-01 06:00:00	QQQ	ETF	87.69	87.75	87.69	87.75	48000.0
2014-04-01 06:30:00	QQQ	ETF	87.77	87.95	87.77	87.95	65920.0
2014-04-01 07:00:00	QQQ	ETF	87.93	87.93	87.83	87.86	66000.0
2014-04-01 07:30:00	QQQ	ETF	87.9	87.97	87.88	87.97	137355.0
2014-04-01 08:00:00	QQQ	ETF	87.66	87.95	87.66	87.89	236270.0
2014-04-01 08:30:00	QQQ	ETF	87.89	87.95	87.88	87.91	157988.0
2014-04-01 09:00:00	QQQ	ETF	87.92	88.11	87.67	88.1	141913.0
2014-04-01 09:30:00	QQQ	ETF	88.1	88.79	88.08	88.74	6505236.0
2014-04-01 10:00:00	QQQ	ETF	88.73	88.92	88.72	88.9	3593613.0
2014-04-01 10:30:00	QQQ	ETF	88.91	89.04	88.82	88.91	3217315.0
2014-04-01 11:00:00	QQQ	ETF	88.89	88.94	88.74	88.82	2000882.0
2014-04-01 11:30:00	QQQ	ETF	88.82	88.915	88.75	88.76	1599830.0
2014-04-01 12:00:00	QQQ	ETF	88.76	88.825	88.66	88.8	1328665.0
2014-04-01 12:30:00	QQQ	ETF	88.805	88.85	88.75	88.75	913802.0
2014-04-01 13:00:00	QQQ	ETF	88.74	88.75	88.61	88.741	2011401.0

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

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