PREVIEW / etf_30min / 2014-01-27

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-27.parquet
  size:    378 KB
  rows:    12,454

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-01-27 04:00:00	SPY	ETF	179.05	179.28	178.96	179.06	19229.0
2014-01-27 04:30:00	SPY	ETF	179.06	179.16	178.71	179.13	80322.0
2014-01-27 05:00:00	SPY	ETF	179.13	179.16	178.77	178.81	17602.0
2014-01-27 05:30:00	SPY	ETF	178.79	179.16	178.67	179.13	39877.0
2014-01-27 06:00:00	SPY	ETF	179.11	179.15	178.88	179.06	81436.0
2014-01-27 06:30:00	SPY	ETF	179.1	179.49	179.1	179.43	164661.0
2014-01-27 07:00:00	SPY	ETF	179.43	179.53	179.35	179.46	523593.0
2014-01-27 07:30:00	SPY	ETF	179.48	179.63	179.27	179.31	1063818.0
2014-01-27 08:00:00	SPY	ETF	179.28	179.5	178.73	179.38	673655.0
2014-01-27 08:30:00	SPY	ETF	179.38	179.47	179.16	179.35	757879.0
2014-01-27 09:00:00	SPY	ETF	179.34	179.34	179.06	179.06	1474485.0
2014-01-27 09:30:00	SPY	ETF	179.06	179.52	178.88	179.3	17806864.0
2014-01-27 10:00:00	SPY	ETF	179.3	179.4	178.1101	178.18	15495887.0
2014-01-27 10:30:00	SPY	ETF	178.17	178.74	178.07	178.36	15277508.0
2014-01-27 11:00:00	SPY	ETF	178.35	178.61	178.13	178.35	9436050.0
2014-01-27 11:30:00	SPY	ETF	178.3599	178.37	177.75	177.83	11460777.0
2014-01-27 12:00:00	SPY	ETF	177.8399	177.84	177.12	177.495	15080637.0
2014-01-27 12:30:00	SPY	ETF	177.51	177.8495	177.315	177.58	9798824.0
2014-01-27 13:00:00	SPY	ETF	177.58	178.22	177.47	178.09	11150319.0
2014-01-27 13:30:00	SPY	ETF	178.1	178.735	177.93	178.43	10953945.0
2014-01-27 14:00:00	SPY	ETF	178.44	178.88	178.435	178.78	9398844.0
2014-01-27 14:30:00	SPY	ETF	178.79	179.27	178.75	179.2	9043392.0
2014-01-27 15:00:00	SPY	ETF	179.19	179.25	178.7497	178.76	7978103.0
2014-01-27 15:30:00	SPY	ETF	178.76	178.93	177.98	178.01	18368327.0
2014-01-27 16:00:00	SPY	ETF	178.01	179.0653	177.75	177.91	9451488.0
2014-01-27 16:30:00	SPY	ETF	177.92	178.6491	177.56	177.74	3019877.0
2014-01-27 17:00:00	SPY	ETF	177.73	177.77	177.54	177.56	362144.0
2014-01-27 17:30:00	SPY	ETF	177.56	177.56	177.43	177.56	111796.0
2014-01-27 18:00:00	SPY	ETF	177.56	178.05	177.54	178.0	486821.0
2014-01-27 18:30:00	SPY	ETF	178.02	178.08	177.92	177.96	114970.0
2014-01-27 19:00:00	SPY	ETF	177.97	178.02	177.88	177.96	185469.0
2014-01-27 19:30:00	SPY	ETF	177.97	178.05	177.97	178.04	94891.0
2014-01-27 04:00:00	QQQ	ETF	86.8	86.83	86.8	86.83	603.0
2014-01-27 04:30:00	QQQ	ETF	86.85	86.85	86.8	86.83	8795.0
2014-01-27 05:00:00	QQQ	ETF	86.83	86.83	86.65	86.65	6000.0
2014-01-27 05:30:00	QQQ	ETF	86.78	86.78	86.74	86.74	1800.0
2014-01-27 06:00:00	QQQ	ETF	86.74	86.79	86.73	86.75	2600.0
2014-01-27 06:30:00	QQQ	ETF	86.8	86.86	86.78	86.86	2620.0
2014-01-27 07:00:00	QQQ	ETF	86.85	86.91	86.79	86.9	65870.0
2014-01-27 07:30:00	QQQ	ETF	86.95	86.95	86.79	86.8	13800.0
2014-01-27 08:00:00	QQQ	ETF	86.79	86.94	86.78	86.83	91863.0
2014-01-27 08:30:00	QQQ	ETF	86.83	86.85	86.74	86.81	92746.0
2014-01-27 09:00:00	QQQ	ETF	86.81	86.89	86.78	86.78	509218.0
2014-01-27 09:30:00	QQQ	ETF	86.77	86.89	86.49	86.68	7310498.0
2014-01-27 10:00:00	QQQ	ETF	86.68	86.78	85.85	85.91	6278985.0
2014-01-27 10:30:00	QQQ	ETF	85.9	86.275	85.68	86.07	6451007.0
2014-01-27 11:00:00	QQQ	ETF	86.06	86.23	85.9	86.09	3410399.0
2014-01-27 11:30:00	QQQ	ETF	86.09	86.1301	85.8	85.84	2756631.0
2014-01-27 12:00:00	QQQ	ETF	85.83	85.84	85.25	85.53	7293601.0
2014-01-27 12:30:00	QQQ	ETF	85.52	85.75	85.35	85.6	4018181.0

> showing 50 of 12,454 rows — these rows as CSV

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