PREVIEW / etf_30min / 2013-01-04

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-04.parquet
  size:    313 KB
  rows:    10,562

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-01-04 04:30:00	SPY	ETF	145.79	145.79	145.75	145.75	2700.0
2013-01-04 05:00:00	SPY	ETF	145.72	145.72	145.68	145.68	4200.0
2013-01-04 05:30:00	SPY	ETF	145.7	145.77	145.69	145.77	7632.0
2013-01-04 06:00:00	SPY	ETF	145.77	145.77	145.72	145.72	400.0
2013-01-04 06:30:00	SPY	ETF	145.72	145.72	145.66	145.68	6950.0
2013-01-04 07:00:00	SPY	ETF	145.73	145.79	145.73	145.79	32150.0
2013-01-04 07:30:00	SPY	ETF	145.77	145.79	145.66	145.69	209586.0
2013-01-04 08:00:00	SPY	ETF	145.68	145.93	145.5	145.93	2246858.0
2013-01-04 08:30:00	SPY	ETF	145.84	146.1	145.49	145.99	2544554.0
2013-01-04 09:00:00	SPY	ETF	146.0	146.11	145.92	145.97	729990.0
2013-01-04 09:30:00	SPY	ETF	145.97	146.16	145.67	146.13	11424769.0
2013-01-04 10:00:00	SPY	ETF	146.15	146.21	145.83	146.07	11022016.0
2013-01-04 10:30:00	SPY	ETF	146.07	146.11	145.73	145.84	9672487.0
2013-01-04 11:00:00	SPY	ETF	145.84	146.06	145.84	146.0	4451052.0
2013-01-04 11:30:00	SPY	ETF	145.99	146.26	145.97	146.09	6876445.0
2013-01-04 12:00:00	SPY	ETF	146.1	146.22	146.09	146.215	2379994.0
2013-01-04 12:30:00	SPY	ETF	146.215	146.24	146.09	146.1	3554944.0
2013-01-04 13:00:00	SPY	ETF	146.1	146.21	146.07	146.2	3488583.0
2013-01-04 13:30:00	SPY	ETF	146.19	146.29	146.1	146.2	3296168.0
2013-01-04 14:00:00	SPY	ETF	146.2	146.29	146.15	146.26	4709759.0
2013-01-04 14:30:00	SPY	ETF	146.268	146.32	146.17	146.3199	5320543.0
2013-01-04 15:00:00	SPY	ETF	146.32	146.61	146.26	146.57	9634798.0
2013-01-04 15:30:00	SPY	ETF	146.575	146.61	146.34	146.38	19531291.0
2013-01-04 16:00:00	SPY	ETF	146.39	146.45	145.7356	146.22	11251483.0
2013-01-04 16:30:00	SPY	ETF	146.21	146.35	146.19	146.26	1461015.0
2013-01-04 17:00:00	SPY	ETF	146.25	146.3	146.24	146.24	25982.0
2013-01-04 17:30:00	SPY	ETF	146.25	146.35	146.24	146.34	45718.0
2013-01-04 18:00:00	SPY	ETF	146.35	146.37	146.2	146.2	47424.0
2013-01-04 18:30:00	SPY	ETF	146.22	146.28	146.22	146.27	2140.0
2013-01-04 19:00:00	SPY	ETF	146.25	146.27	146.24	146.25	3430.0
2013-01-04 19:30:00	SPY	ETF	146.25	146.34	146.23	146.33	11294.0
2013-01-04 04:00:00	QQQ	ETF	66.9	66.9	66.9	66.9	200.0
2013-01-04 06:00:00	QQQ	ETF	66.86	66.86	66.86	66.86	500.0
2013-01-04 06:30:00	QQQ	ETF	66.86	66.86	66.86	66.86	10000.0
2013-01-04 07:00:00	QQQ	ETF	66.92	66.93	66.91	66.93	21100.0
2013-01-04 07:30:00	QQQ	ETF	66.91	66.98	66.91	66.93	22910.0
2013-01-04 08:00:00	QQQ	ETF	66.92	67.03	66.89	67.0	428451.0
2013-01-04 08:30:00	QQQ	ETF	66.95	67.07	66.87	66.92	945740.0
2013-01-04 09:00:00	QQQ	ETF	66.92	66.98	66.86	66.88	342505.0
2013-01-04 09:30:00	QQQ	ETF	66.88	66.88	66.68	66.84	4090084.0
2013-01-04 10:00:00	QQQ	ETF	66.84	66.87	66.58	66.66	3574338.0
2013-01-04 10:30:00	QQQ	ETF	66.67	66.67	66.47	66.53	3330541.0
2013-01-04 11:00:00	QQQ	ETF	66.53	66.68	66.53	66.61	1431990.0
2013-01-04 11:30:00	QQQ	ETF	66.62	66.81	66.59	66.74	2272272.0
2013-01-04 12:00:00	QQQ	ETF	66.74	66.83	66.73	66.811	1132699.0
2013-01-04 12:30:00	QQQ	ETF	66.8181	66.84	66.6737	66.69	1316159.0
2013-01-04 13:00:00	QQQ	ETF	66.696	66.74	66.65	66.74	1150545.0
2013-01-04 13:30:00	QQQ	ETF	66.73	66.76	66.65	66.68	656068.0
2013-01-04 14:00:00	QQQ	ETF	66.68	66.755	66.66	66.73	1046916.0
2013-01-04 14:30:00	QQQ	ETF	66.73	66.78	66.69	66.78	1634148.0

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

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