PREVIEW / etf_30min / 2010-04-22

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-22.parquet
  size:    263 KB
  rows:    8,616

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
2010-04-22 04:00:00	SPY	ETF	120.73	120.86	120.73	120.86	8700.0
2010-04-22 04:30:00	SPY	ETF	120.7	120.75	120.7	120.75	400.0
2010-04-22 05:00:00	SPY	ETF	120.66	120.66	120.0	120.03	12966.0
2010-04-22 05:30:00	SPY	ETF	120.03	120.12	119.95	120.07	2800.0
2010-04-22 06:00:00	SPY	ETF	119.93	120.08	119.87	120.08	11000.0
2010-04-22 06:30:00	SPY	ETF	119.97	120.02	119.73	119.89	148600.0
2010-04-22 07:00:00	SPY	ETF	119.89	119.94	119.77	119.81	152473.0
2010-04-22 07:30:00	SPY	ETF	119.81	120.02	119.76	119.98	284620.0
2010-04-22 08:00:00	SPY	ETF	119.98	120.06	119.9	119.94	1220455.0
2010-04-22 08:30:00	SPY	ETF	119.94	119.96	119.83	119.86	1288929.0
2010-04-22 09:00:00	SPY	ETF	119.86	120.19	119.71	119.83	1320432.0
2010-04-22 09:30:00	SPY	ETF	119.81	119.84	119.13	119.46	34102939.0
2010-04-22 10:00:00	SPY	ETF	119.46	119.95	119.32	119.8	23032967.0
2010-04-22 10:30:00	SPY	ETF	119.78	120.01	119.45	119.78	31731963.0
2010-04-22 11:00:00	SPY	ETF	119.78	119.91	119.555	119.68	11895916.0
2010-04-22 11:30:00	SPY	ETF	119.68	119.85	119.42	119.65	14309733.0
2010-04-22 12:00:00	SPY	ETF	119.65	119.89	119.56	119.85	10759421.0
2010-04-22 12:30:00	SPY	ETF	119.84	119.94	119.6	119.87	7068208.0
2010-04-22 13:00:00	SPY	ETF	119.87	120.51	119.12	120.42	21341298.0
2010-04-22 13:30:00	SPY	ETF	120.42	120.63	120.27	120.62	10068371.0
2010-04-22 14:00:00	SPY	ETF	120.63	120.83	120.45	120.8	9935998.0
2010-04-22 14:30:00	SPY	ETF	120.8	120.82	120.53	120.65	12663757.0
2010-04-22 15:00:00	SPY	ETF	120.64	120.97	120.58	120.961	12362264.0
2010-04-22 15:30:00	SPY	ETF	120.96	121.17	120.65	121.0	20985153.0
2010-04-22 16:00:00	SPY	ETF	121.0	121.05	119.4	120.66	12512823.0
2010-04-22 16:30:00	SPY	ETF	120.62	120.76	120.56	120.74	546388.0
2010-04-22 17:00:00	SPY	ETF	120.75	121.02	120.67	120.74	98171.0
2010-04-22 17:30:00	SPY	ETF	120.76	120.8	120.7	120.7	100744.0
2010-04-22 18:00:00	SPY	ETF	120.72	120.73	120.62	120.62	30866.0
2010-04-22 18:30:00	SPY	ETF	120.64	120.65	120.59	120.62	16323.0
2010-04-22 19:00:00	SPY	ETF	120.65	120.65	120.57	120.58	12473.0
2010-04-22 19:30:00	SPY	ETF	120.58	120.63	120.57	120.57	24030.0
2010-04-22 04:30:00	QQQ	ETF	49.95	49.95	49.95	49.95	100.0
2010-04-22 05:00:00	QQQ	ETF	49.76	49.76	49.76	49.76	500.0
2010-04-22 05:30:00	QQQ	ETF	49.75	49.75	49.74	49.74	1000.0
2010-04-22 06:00:00	QQQ	ETF	49.67	49.67	49.6	49.63	10000.0
2010-04-22 06:30:00	QQQ	ETF	49.63	49.63	49.54	49.54	3139.0
2010-04-22 07:00:00	QQQ	ETF	49.57	49.61	49.55	49.61	81935.0
2010-04-22 07:30:00	QQQ	ETF	49.58	49.62	49.56	49.6	368536.0
2010-04-22 08:00:00	QQQ	ETF	49.75	49.75	49.54	49.56	3532454.0
2010-04-22 08:30:00	QQQ	ETF	49.55	49.58	49.5	49.56	720679.0
2010-04-22 09:00:00	QQQ	ETF	49.56	49.57	49.515	49.56	511417.0
2010-04-22 09:30:00	QQQ	ETF	49.56	49.59	49.26	49.439	15578090.0
2010-04-22 10:00:00	QQQ	ETF	49.44	49.64	49.41	49.62	7169310.0
2010-04-22 10:30:00	QQQ	ETF	49.62	49.82	49.47	49.71	16117088.0
2010-04-22 11:00:00	QQQ	ETF	49.71	49.75	49.55	49.58	5427721.0
2010-04-22 11:30:00	QQQ	ETF	49.59	49.6	49.49	49.53	4365980.0
2010-04-22 12:00:00	QQQ	ETF	49.535	49.7	49.5	49.68	6995999.0
2010-04-22 12:30:00	QQQ	ETF	49.68	49.72	49.62	49.679	2900950.0
2010-04-22 13:00:00	QQQ	ETF	49.67	49.94	49.6575	49.9095	5848524.0

> showing 50 of 8,616 rows — these rows as CSV

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