PREVIEW / etf_30min / 2012-01-19

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-19.parquet
  size:    294 KB
  rows:    9,910

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-19 04:00:00	SPY	ETF	130.6	130.6	130.5	130.5	7550.0
2012-01-19 04:30:00	SPY	ETF	130.68	130.68	130.6	130.6	3000.0
2012-01-19 05:00:00	SPY	ETF	130.48	130.58	130.43	130.58	7000.0
2012-01-19 05:30:00	SPY	ETF	130.66	130.78	130.61	130.78	8400.0
2012-01-19 06:00:00	SPY	ETF	130.74	130.74	130.73	130.73	300.0
2012-01-19 06:30:00	SPY	ETF	130.8	130.85	130.78	130.79	14840.0
2012-01-19 07:00:00	SPY	ETF	130.78	131.07	130.75	131.07	250347.0
2012-01-19 07:30:00	SPY	ETF	131.07	131.28	131.06	131.17	508330.0
2012-01-19 08:00:00	SPY	ETF	131.14	131.29	131.09	131.18	572976.0
2012-01-19 08:30:00	SPY	ETF	131.2	131.5	130.8	131.14	1937831.0
2012-01-19 09:00:00	SPY	ETF	131.14	131.23	131.02	131.21	1485954.0
2012-01-19 09:30:00	SPY	ETF	131.22	131.27	130.98	131.24	15807922.0
2012-01-19 10:00:00	SPY	ETF	131.23	131.235	130.8	131.14	11822769.0
2012-01-19 10:30:00	SPY	ETF	131.14	131.42	131.1	131.24	8279517.0
2012-01-19 11:00:00	SPY	ETF	131.24	131.49	131.18	131.46	7172601.0
2012-01-19 11:30:00	SPY	ETF	131.457	131.54	131.39	131.53	7431266.0
2012-01-19 12:00:00	SPY	ETF	131.5274	131.54	131.36	131.38	5161857.0
2012-01-19 12:30:00	SPY	ETF	131.38	131.41	131.27	131.36	3898867.0
2012-01-19 13:00:00	SPY	ETF	131.35	131.57	131.34	131.55	7245945.0
2012-01-19 13:30:00	SPY	ETF	131.55	131.57	131.36	131.37	6134606.0
2012-01-19 14:00:00	SPY	ETF	131.361	131.54	131.36	131.42	5323182.0
2012-01-19 14:30:00	SPY	ETF	131.425	131.45	131.2	131.21	6582837.0
2012-01-19 15:00:00	SPY	ETF	131.205	131.48	131.19	131.41	9175354.0
2012-01-19 15:30:00	SPY	ETF	131.42	131.48	131.28	131.48	14998604.0
2012-01-19 16:00:00	SPY	ETF	131.47	131.53	131.03	131.47	8087263.0
2012-01-19 16:30:00	SPY	ETF	131.44	131.53	131.3404	131.5	1351827.0
2012-01-19 17:00:00	SPY	ETF	131.46	131.488	131.39	131.4	576998.0
2012-01-19 17:30:00	SPY	ETF	131.4	131.46	131.38	131.44	89780.0
2012-01-19 18:00:00	SPY	ETF	131.43	131.48	131.35	131.36	186416.0
2012-01-19 18:30:00	SPY	ETF	131.37	131.44	131.36	131.42	48664.0
2012-01-19 19:00:00	SPY	ETF	131.42	131.42	131.35	131.38	47200.0
2012-01-19 19:30:00	SPY	ETF	131.37	131.41	131.36	131.38	78205.0
2012-01-19 05:30:00	QQQ	ETF	59.52	59.57	59.52	59.57	400.0
2012-01-19 06:00:00	QQQ	ETF	59.56	59.58	59.56	59.58	20100.0
2012-01-19 06:30:00	QQQ	ETF	59.59	59.6	59.58	59.58	1500.0
2012-01-19 07:00:00	QQQ	ETF	59.59	59.66	59.56	59.66	39250.0
2012-01-19 07:30:00	QQQ	ETF	59.66	59.7	59.65	59.67	9300.0
2012-01-19 08:00:00	QQQ	ETF	59.66	59.71	59.65	59.68	146304.0
2012-01-19 08:30:00	QQQ	ETF	59.69	59.8	59.67	59.69	336593.0
2012-01-19 09:00:00	QQQ	ETF	59.69	59.77	59.67	59.76	375471.0
2012-01-19 09:30:00	QQQ	ETF	59.76	59.84	59.67	59.821	5451281.0
2012-01-19 10:00:00	QQQ	ETF	59.82	59.82	59.65	59.79	3807192.0
2012-01-19 10:30:00	QQQ	ETF	59.79	59.91	59.74	59.83	2739678.0
2012-01-19 11:00:00	QQQ	ETF	59.84	59.955	59.83	59.93	1896885.0
2012-01-19 11:30:00	QQQ	ETF	59.93	59.97	59.89	59.94	1701332.0
2012-01-19 12:00:00	QQQ	ETF	59.95	59.95	59.89	59.91	1236288.0
2012-01-19 12:30:00	QQQ	ETF	59.9	59.92	59.85	59.88	1049506.0
2012-01-19 13:00:00	QQQ	ETF	59.88	59.95	59.87	59.9399	1535907.0
2012-01-19 13:30:00	QQQ	ETF	59.93	59.958	59.84	59.845	1675241.0
2012-01-19 14:00:00	QQQ	ETF	59.85	59.95	59.85	59.905	4529348.0

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

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