PREVIEW / etf_30min / 2009-06-30

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-30.parquet
  size:    211 KB
  rows:    7,066

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
2009-06-30 04:00:00	SPY	ETF	92.75	92.75	92.75	92.75	100.0
2009-06-30 04:30:00	SPY	ETF	92.75	92.75	92.73	92.73	3000.0
2009-06-30 05:00:00	SPY	ETF	92.83	92.84	92.83	92.84	5000.0
2009-06-30 05:30:00	SPY	ETF	92.91	92.93	92.91	92.93	2000.0
2009-06-30 06:00:00	SPY	ETF	92.92	92.92	92.83	92.83	700.0
2009-06-30 06:30:00	SPY	ETF	92.88	92.88	92.87	92.87	1200.0
2009-06-30 07:00:00	SPY	ETF	92.87	92.88	92.68	92.71	39300.0
2009-06-30 07:30:00	SPY	ETF	92.72	92.76	92.7	92.71	123475.0
2009-06-30 08:00:00	SPY	ETF	92.71	92.75	92.64	92.66	299216.0
2009-06-30 08:30:00	SPY	ETF	92.67	92.84	92.67	92.83	329872.0
2009-06-30 09:00:00	SPY	ETF	92.84	92.95	92.68	92.73	1080633.0
2009-06-30 09:30:00	SPY	ETF	92.72	93.06	92.65	92.87	18945670.0
2009-06-30 10:00:00	SPY	ETF	92.9	92.91	91.8	91.91	36295374.0
2009-06-30 10:30:00	SPY	ETF	91.91	91.91	91.52	91.74	19030040.0
2009-06-30 11:00:00	SPY	ETF	91.7483	91.82	91.51	91.59	13026887.0
2009-06-30 11:30:00	SPY	ETF	91.59	91.59	91.27	91.48	14512179.0
2009-06-30 12:00:00	SPY	ETF	91.47	91.62	91.38	91.6	8097412.0
2009-06-30 12:30:00	SPY	ETF	91.5901	91.72	91.56	91.6683	5221546.0
2009-06-30 13:00:00	SPY	ETF	91.67	91.67	91.47	91.52	6216573.0
2009-06-30 13:30:00	SPY	ETF	91.52	91.65	91.39	91.45	8097151.0
2009-06-30 14:00:00	SPY	ETF	91.45	91.69	91.37	91.64	8144903.0
2009-06-30 14:30:00	SPY	ETF	91.65	91.83	91.55	91.7001	9435346.0
2009-06-30 15:00:00	SPY	ETF	91.7	91.86	91.58	91.78	12954934.0
2009-06-30 15:30:00	SPY	ETF	91.775	92.085	91.74	92.03	30069364.0
2009-06-30 16:00:00	SPY	ETF	92.04	92.7408	91.38	92.01	12879757.0
2009-06-30 16:30:00	SPY	ETF	92.02	92.03	91.97	92.03	8758639.0
2009-06-30 17:00:00	SPY	ETF	92.02	92.02	91.97	91.98	315288.0
2009-06-30 17:30:00	SPY	ETF	91.99	92.02	91.96	91.98	1545918.0
2009-06-30 18:00:00	SPY	ETF	91.98	91.99	91.93	91.93	26263.0
2009-06-30 18:30:00	SPY	ETF	91.95	91.96	91.9	91.9	29500.0
2009-06-30 19:00:00	SPY	ETF	91.88	91.92	91.88	91.91	7600.0
2009-06-30 19:30:00	SPY	ETF	91.91	91.96	91.9	91.92	17920.0
2009-06-30 04:30:00	QQQ	ETF	36.56	36.58	36.56	36.58	715.0
2009-06-30 05:00:00	QQQ	ETF	36.54	36.58	36.54	36.58	5100.0
2009-06-30 05:30:00	QQQ	ETF	36.6	36.6	36.6	36.6	2500.0
2009-06-30 06:00:00	QQQ	ETF	36.56	36.56	36.56	36.56	100.0
2009-06-30 06:30:00	QQQ	ETF	36.57	36.58	36.55	36.56	900.0
2009-06-30 07:00:00	QQQ	ETF	36.58	36.58	36.51	36.53	41714.0
2009-06-30 07:30:00	QQQ	ETF	36.53	36.54	36.53	36.54	14700.0
2009-06-30 08:00:00	QQQ	ETF	36.54	36.57	36.49	36.51	462985.0
2009-06-30 08:30:00	QQQ	ETF	36.51	36.56	36.51	36.55	100453.0
2009-06-30 09:00:00	QQQ	ETF	36.56	36.59	36.54	36.56	458603.0
2009-06-30 09:30:00	QQQ	ETF	36.55	36.73	36.5	36.65	9785743.0
2009-06-30 10:00:00	QQQ	ETF	36.65	36.67	36.27	36.31	15054308.0
2009-06-30 10:30:00	QQQ	ETF	36.3	36.38	36.18	36.3501	7803359.0
2009-06-30 11:00:00	QQQ	ETF	36.36	36.38	36.2	36.28	4551817.0
2009-06-30 11:30:00	QQQ	ETF	36.28	36.28	36.19	36.23	5194292.0
2009-06-30 12:00:00	QQQ	ETF	36.2299	36.25	36.14	36.23	5025185.0
2009-06-30 12:30:00	QQQ	ETF	36.23	36.29	36.21	36.23	3726420.0
2009-06-30 13:00:00	QQQ	ETF	36.2295	36.23	36.16	36.17	3662812.0

> showing 50 of 7,066 rows — these rows as CSV

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