PREVIEW / etf_30min / 2012-01-24

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-24.parquet
  size:    288 KB
  rows:    9,741

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
2012-01-24 04:00:00	SPY	ETF	131.2	131.2	131.18	131.18	500.0
2012-01-24 04:30:00	SPY	ETF	131.2	131.2	130.96	131.01	2700.0
2012-01-24 05:00:00	SPY	ETF	130.96	131.09	130.96	131.05	30100.0
2012-01-24 05:30:00	SPY	ETF	131.0	131.0	130.85	130.87	27200.0
2012-01-24 06:00:00	SPY	ETF	130.85	130.92	130.74	130.84	42880.0
2012-01-24 06:30:00	SPY	ETF	130.85	130.95	130.7	130.73	87035.0
2012-01-24 07:00:00	SPY	ETF	130.74	131.05	130.74	130.95	129775.0
2012-01-24 07:30:00	SPY	ETF	130.99	131.02	130.77	130.86	281564.0
2012-01-24 08:00:00	SPY	ETF	130.87	130.99	130.84	130.92	233644.0
2012-01-24 08:30:00	SPY	ETF	130.94	130.95	130.67	130.75	959513.0
2012-01-24 09:00:00	SPY	ETF	130.74	130.9	130.7	130.81	1377328.0
2012-01-24 09:30:00	SPY	ETF	130.8	130.94	130.6	130.8	15318220.0
2012-01-24 10:00:00	SPY	ETF	130.8	131.12	130.72	130.98	12244127.0
2012-01-24 10:30:00	SPY	ETF	130.98	131.3	130.89	131.19	8528985.0
2012-01-24 11:00:00	SPY	ETF	131.1807	131.41	131.11	131.38	6777871.0
2012-01-24 11:30:00	SPY	ETF	131.38	131.41	131.18	131.22	5261678.0
2012-01-24 12:00:00	SPY	ETF	131.22	131.37	131.2	131.22	4124083.0
2012-01-24 12:30:00	SPY	ETF	131.21	131.4	131.2	131.36	2850338.0
2012-01-24 13:00:00	SPY	ETF	131.37	131.38	131.13	131.16	4832721.0
2012-01-24 13:30:00	SPY	ETF	131.17	131.29	131.1	131.2698	3989752.0
2012-01-24 14:00:00	SPY	ETF	131.27	131.39	131.24	131.36	4225530.0
2012-01-24 14:30:00	SPY	ETF	131.36	131.46	131.26	131.32	5516853.0
2012-01-24 15:00:00	SPY	ETF	131.32	131.5	131.29	131.48	7632391.0
2012-01-24 15:30:00	SPY	ETF	131.47	131.5	131.29	131.46	11388633.0
2012-01-24 16:00:00	SPY	ETF	131.465	131.7	130.83	131.6	3860358.0
2012-01-24 16:30:00	SPY	ETF	131.61	132.09	131.17	131.91	1917704.0
2012-01-24 17:00:00	SPY	ETF	131.92	132.0	131.9	131.96	222296.0
2012-01-24 17:30:00	SPY	ETF	131.96	132.03	131.93	132.0	131939.0
2012-01-24 18:00:00	SPY	ETF	131.98	131.99	131.46	131.91	162855.0
2012-01-24 18:30:00	SPY	ETF	131.91	131.91	131.84	131.86	14898.0
2012-01-24 19:00:00	SPY	ETF	131.86	131.9	131.85	131.89	63212.0
2012-01-24 19:30:00	SPY	ETF	131.87	132.01	131.87	132.0	150402.0
2012-01-24 04:00:00	QQQ	ETF	59.77	59.77	59.77	59.77	224.0
2012-01-24 06:00:00	QQQ	ETF	59.77	59.83	59.53	59.66	37380.0
2012-01-24 06:30:00	QQQ	ETF	59.66	59.66	59.49	59.59	8500.0
2012-01-24 07:00:00	QQQ	ETF	59.5	59.6	59.5	59.59	42400.0
2012-01-24 07:30:00	QQQ	ETF	59.62	59.62	59.53	59.55	5100.0
2012-01-24 08:00:00	QQQ	ETF	59.57	59.59	59.53	59.58	86899.0
2012-01-24 08:30:00	QQQ	ETF	59.56	59.56	59.48	59.49	104393.0
2012-01-24 09:00:00	QQQ	ETF	59.49	59.56	59.49	59.53	199725.0
2012-01-24 09:30:00	QQQ	ETF	59.54	59.59	59.41	59.49	5706904.0
2012-01-24 10:00:00	QQQ	ETF	59.49	59.69	59.44	59.6107	4579503.0
2012-01-24 10:30:00	QQQ	ETF	59.61	59.84	59.57	59.74	3725591.0
2012-01-24 11:00:00	QQQ	ETF	59.75	59.84	59.68	59.81	2114365.0
2012-01-24 11:30:00	QQQ	ETF	59.81	59.82	59.67	59.69	1384609.0
2012-01-24 12:00:00	QQQ	ETF	59.69	59.78	59.65	59.66	964494.0
2012-01-24 12:30:00	QQQ	ETF	59.6565	59.73	59.63	59.71	896715.0
2012-01-24 13:00:00	QQQ	ETF	59.71	59.71	59.57	59.5893	1043803.0
2012-01-24 13:30:00	QQQ	ETF	59.5815	59.65	59.53	59.65	1109316.0
2012-01-24 14:00:00	QQQ	ETF	59.65	59.715	59.64	59.685	899746.0

> showing 50 of 9,741 rows — these rows as CSV

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