PREVIEW / etf_30min / 2014-03-12

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-12.parquet
  size:    330 KB
  rows:    11,220

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-03-12 04:00:00	SPY	ETF	186.95	187.12	186.89	187.04	5489.0
2014-03-12 04:30:00	SPY	ETF	187.05	187.08	186.97	186.98	5950.0
2014-03-12 05:00:00	SPY	ETF	186.97	186.97	186.67	186.72	11723.0
2014-03-12 05:30:00	SPY	ETF	186.75	186.86	186.75	186.78	7759.0
2014-03-12 06:00:00	SPY	ETF	186.74	186.77	186.54	186.58	53842.0
2014-03-12 06:30:00	SPY	ETF	186.62	186.71	186.4	186.43	117371.0
2014-03-12 07:00:00	SPY	ETF	186.43	186.57	186.42	186.5	255199.0
2014-03-12 07:30:00	SPY	ETF	186.52	186.7	186.47	186.69	104239.0
2014-03-12 08:00:00	SPY	ETF	186.68	186.73	186.46	186.54	280313.0
2014-03-12 08:30:00	SPY	ETF	186.56	186.57	186.26	186.42	965631.0
2014-03-12 09:00:00	SPY	ETF	186.41	186.55	186.23	186.3	1027054.0
2014-03-12 09:30:00	SPY	ETF	186.32	186.62	185.9	186.29	19598998.0
2014-03-12 10:00:00	SPY	ETF	186.29	186.8	186.23	186.569	11393167.0
2014-03-12 10:30:00	SPY	ETF	186.56	187.01	186.41	186.961	9109071.0
2014-03-12 11:00:00	SPY	ETF	186.96	187.35	186.8	187.25	8131039.0
2014-03-12 11:30:00	SPY	ETF	187.25	187.29	186.87	186.88	4461578.0
2014-03-12 12:00:00	SPY	ETF	186.88	187.1	186.79	186.885	4705156.0
2014-03-12 12:30:00	SPY	ETF	186.885	187.2	186.7601	187.17	4511050.0
2014-03-12 13:00:00	SPY	ETF	187.169	187.18	186.75	186.88	2770945.0
2014-03-12 13:30:00	SPY	ETF	186.88	187.08	186.83	187.0	2510487.0
2014-03-12 14:00:00	SPY	ETF	187.0	187.21	186.87	187.14	4337385.0
2014-03-12 14:30:00	SPY	ETF	187.14	187.17	186.9	186.92	3696157.0
2014-03-12 15:00:00	SPY	ETF	186.92	187.03	186.79	186.84	5533636.0
2014-03-12 15:30:00	SPY	ETF	186.84	187.33	186.77	187.26	13245400.0
2014-03-12 16:00:00	SPY	ETF	187.26	187.35	186.05	187.31	6606468.0
2014-03-12 16:30:00	SPY	ETF	187.31	187.38	187.3019	187.37	296718.0
2014-03-12 17:00:00	SPY	ETF	187.38	187.39	187.28	187.32	49885.0
2014-03-12 17:30:00	SPY	ETF	187.32	187.32	187.29	187.31	22600.0
2014-03-12 18:00:00	SPY	ETF	187.32	187.34	187.22	187.23	33670.0
2014-03-12 18:30:00	SPY	ETF	187.25	187.3	187.25	187.3	14086.0
2014-03-12 19:00:00	SPY	ETF	187.31	187.39	187.31	187.37	28948.0
2014-03-12 19:30:00	SPY	ETF	187.39	187.48	187.39	187.48	45228.0
2014-03-12 04:00:00	QQQ	ETF	90.1	90.11	90.09	90.1	7500.0
2014-03-12 05:00:00	QQQ	ETF	90.05	90.05	90.05	90.05	2500.0
2014-03-12 05:30:00	QQQ	ETF	90.01	90.01	90.01	90.01	300.0
2014-03-12 06:00:00	QQQ	ETF	89.9	89.92	89.9	89.92	3600.0
2014-03-12 06:30:00	QQQ	ETF	89.88	89.88	89.8	89.86	9400.0
2014-03-12 07:00:00	QQQ	ETF	89.84	89.88	89.81	89.84	8200.0
2014-03-12 07:30:00	QQQ	ETF	89.85	89.955	89.84	89.9	11615.0
2014-03-12 08:00:00	QQQ	ETF	89.88	89.94	89.88	89.9	36366.0
2014-03-12 08:30:00	QQQ	ETF	89.88	89.89	89.75	89.81	93446.0
2014-03-12 09:00:00	QQQ	ETF	89.82	89.89	89.72	89.81	118646.0
2014-03-12 09:30:00	QQQ	ETF	89.82	89.98	89.48	89.71	4313316.0
2014-03-12 10:00:00	QQQ	ETF	89.71	90.12	89.68	90.01	2988050.0
2014-03-12 10:30:00	QQQ	ETF	90.01	90.29	89.93	90.28	2526112.0
2014-03-12 11:00:00	QQQ	ETF	90.28	90.6	90.2	90.54	1885453.0
2014-03-12 11:30:00	QQQ	ETF	90.55	90.57	90.36	90.36	1290415.0
2014-03-12 12:00:00	QQQ	ETF	90.36	90.48	90.31	90.36	990652.0
2014-03-12 12:30:00	QQQ	ETF	90.37	90.52	90.291	90.5199	695398.0
2014-03-12 13:00:00	QQQ	ETF	90.52	90.52	90.295	90.368	370806.0

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

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