PREVIEW / etf_30min / 2013-05-13

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-13.parquet
  size:    305 KB
  rows:    10,627

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
2013-05-13 04:00:00	SPY	ETF	163.01	163.01	162.86	162.9	6099.0
2013-05-13 04:30:00	SPY	ETF	162.93	162.94	162.93	162.93	400.0
2013-05-13 05:00:00	SPY	ETF	162.9	162.9	162.8	162.8	13428.0
2013-05-13 05:30:00	SPY	ETF	162.76	162.79	162.71	162.71	2500.0
2013-05-13 06:00:00	SPY	ETF	162.73	162.82	162.71	162.82	6710.0
2013-05-13 06:30:00	SPY	ETF	162.86	162.92	162.84	162.84	50964.0
2013-05-13 07:00:00	SPY	ETF	162.83	162.94	162.83	162.91	211639.0
2013-05-13 07:30:00	SPY	ETF	162.91	163.08	162.91	163.06	229906.0
2013-05-13 08:00:00	SPY	ETF	163.06	163.07	162.71	163.0	630007.0
2013-05-13 08:30:00	SPY	ETF	163.0	163.27	163.0	163.21	872923.0
2013-05-13 09:00:00	SPY	ETF	163.19	163.26	163.09	163.21	697606.0
2013-05-13 09:30:00	SPY	ETF	163.2	163.33	162.82	162.93	10567993.0
2013-05-13 10:00:00	SPY	ETF	162.93	163.4	162.85	163.27	8059851.0
2013-05-13 10:30:00	SPY	ETF	163.275	163.46	163.24	163.3196	6943485.0
2013-05-13 11:00:00	SPY	ETF	163.32	163.46	163.16	163.322	4632681.0
2013-05-13 11:30:00	SPY	ETF	163.34	163.67	163.33	163.63	5912780.0
2013-05-13 12:00:00	SPY	ETF	163.63	163.81	163.61	163.67	3907558.0
2013-05-13 12:30:00	SPY	ETF	163.68	163.73	162.93	163.6201	2364671.0
2013-05-13 13:00:00	SPY	ETF	163.63	163.73	163.55	163.59	2606329.0
2013-05-13 13:30:00	SPY	ETF	163.58	163.59	163.35	163.41	3882583.0
2013-05-13 14:00:00	SPY	ETF	163.41	163.49	163.34	163.44	3592250.0
2013-05-13 14:30:00	SPY	ETF	163.435	163.64	163.43	163.64	3972317.0
2013-05-13 15:00:00	SPY	ETF	163.64	163.67	163.29	163.421	6076165.0
2013-05-13 15:30:00	SPY	ETF	163.42	163.6	163.4	163.54	9822049.0
2013-05-13 16:00:00	SPY	ETF	163.54	163.61	163.3392	163.59	2543612.0
2013-05-13 16:30:00	SPY	ETF	163.59	163.63	163.4167	163.57	437270.0
2013-05-13 17:00:00	SPY	ETF	163.58	163.61	163.54	163.58	1642413.0
2013-05-13 17:30:00	SPY	ETF	163.58	163.61	163.57	163.59	21900.0
2013-05-13 18:00:00	SPY	ETF	163.58	163.6	163.57	163.57	30936.0
2013-05-13 18:30:00	SPY	ETF	163.56	163.6	163.56	163.58	34870.0
2013-05-13 19:00:00	SPY	ETF	163.58	163.68	163.58	163.68	47825.0
2013-05-13 19:30:00	SPY	ETF	163.66	163.77	163.66	163.76	41500.0
2013-05-13 04:00:00	QQQ	ETF	72.78	72.78	72.77	72.77	300.0
2013-05-13 05:30:00	QQQ	ETF	72.69	72.69	72.69	72.69	400.0
2013-05-13 06:00:00	QQQ	ETF	72.71	72.71	72.71	72.71	500.0
2013-05-13 06:30:00	QQQ	ETF	72.73	72.74	72.73	72.74	400.0
2013-05-13 07:00:00	QQQ	ETF	72.74	72.76	72.74	72.74	1850.0
2013-05-13 07:30:00	QQQ	ETF	72.76	72.84	72.76	72.84	29699.0
2013-05-13 08:00:00	QQQ	ETF	72.85	72.86	72.72	72.81	57194.0
2013-05-13 08:30:00	QQQ	ETF	72.85	72.98	72.83	72.96	89884.0
2013-05-13 09:00:00	QQQ	ETF	72.96	72.98	72.89	72.93	142200.0
2013-05-13 09:30:00	QQQ	ETF	72.93	73.08	72.88	72.93	3740618.0
2013-05-13 10:00:00	QQQ	ETF	72.93	73.18	72.86	73.04	4617081.0
2013-05-13 10:30:00	QQQ	ETF	73.04	73.17	73.02	73.04	1022570.0
2013-05-13 11:00:00	QQQ	ETF	73.05	73.1203	72.9299	73.005	1164701.0
2013-05-13 11:30:00	QQQ	ETF	73.02	73.22	73.0	73.21	1737396.0
2013-05-13 12:00:00	QQQ	ETF	73.21	73.32	73.19	73.25	1307358.0
2013-05-13 12:30:00	QQQ	ETF	73.26	73.3	73.2	73.21	548504.0
2013-05-13 13:00:00	QQQ	ETF	73.211	73.26	73.1	73.14	863902.0
2013-05-13 13:30:00	QQQ	ETF	73.13	73.14	73.0	73.06	896810.0

> showing 50 of 10,627 rows — these rows as CSV

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