PREVIEW / etf_30min / 2009-07-01

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-01.parquet
  size:    217 KB
  rows:    7,149

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-07-01 04:00:00	SPY	ETF	92.53	92.59	92.53	92.58	1874.0
2009-07-01 04:30:00	SPY	ETF	92.59	92.67	92.59	92.67	200.0
2009-07-01 05:00:00	SPY	ETF	92.62	92.62	92.62	92.62	2000.0
2009-07-01 05:30:00	SPY	ETF	92.62	92.66	92.6	92.6	60100.0
2009-07-01 06:00:00	SPY	ETF	92.58	92.8	92.58	92.73	7500.0
2009-07-01 06:30:00	SPY	ETF	92.73	92.74	92.5	92.5	12600.0
2009-07-01 07:00:00	SPY	ETF	92.5	92.52	92.35	92.42	265740.0
2009-07-01 07:30:00	SPY	ETF	92.39	92.63	92.39	92.63	771831.0
2009-07-01 08:00:00	SPY	ETF	92.63	92.68	92.0	92.53	4130433.0
2009-07-01 08:30:00	SPY	ETF	92.53	92.67	92.27	92.44	1814415.0
2009-07-01 09:00:00	SPY	ETF	92.43	92.54	92.33	92.35	4954906.0
2009-07-01 09:30:00	SPY	ETF	92.34	92.88	92.33	92.87	20117699.0
2009-07-01 10:00:00	SPY	ETF	92.86	93.22	92.411	93.19	28682532.0
2009-07-01 10:30:00	SPY	ETF	93.19	93.23	93.02	93.0705	9732360.0
2009-07-01 11:00:00	SPY	ETF	93.08	93.14	92.84	92.87	9144846.0
2009-07-01 11:30:00	SPY	ETF	92.85	93.01	92.83	92.96	7776265.0
2009-07-01 12:00:00	SPY	ETF	92.96	93.08	92.81	92.98	8669109.0
2009-07-01 12:30:00	SPY	ETF	92.97	93.0	92.775	92.78	3390804.0
2009-07-01 13:00:00	SPY	ETF	92.79	92.96	92.77	92.95	4517973.0
2009-07-01 13:30:00	SPY	ETF	92.95	92.96	92.79	92.8799	7322431.0
2009-07-01 14:00:00	SPY	ETF	92.88	92.89	92.57	92.69	7286379.0
2009-07-01 14:30:00	SPY	ETF	92.68	92.76	92.54	92.63	10090249.0
2009-07-01 15:00:00	SPY	ETF	92.63	92.73	92.46	92.5	9419168.0
2009-07-01 15:30:00	SPY	ETF	92.5	92.62	92.21	92.34	24651449.0
2009-07-01 16:00:00	SPY	ETF	92.34	93.15	92.26	92.4	8459436.0
2009-07-01 16:30:00	SPY	ETF	92.38	92.4	92.34	92.37	152902.0
2009-07-01 17:00:00	SPY	ETF	92.37	92.4	92.36	92.39	6321.0
2009-07-01 17:30:00	SPY	ETF	91.92	92.44	91.92	92.43	1036308.0
2009-07-01 18:00:00	SPY	ETF	92.41	92.41	92.36	92.37	22986.0
2009-07-01 18:30:00	SPY	ETF	92.37	92.41	92.37	92.37	14600.0
2009-07-01 19:00:00	SPY	ETF	92.4	92.4	92.38	92.4	4700.0
2009-07-01 19:30:00	SPY	ETF	92.38	92.39	92.35	92.39	45850.0
2009-07-01 04:00:00	QQQ	ETF	36.54	36.58	36.54	36.58	3700.0
2009-07-01 06:00:00	QQQ	ETF	36.64	36.68	36.64	36.68	3693.0
2009-07-01 06:30:00	QQQ	ETF	36.66	36.67	36.59	36.59	8100.0
2009-07-01 07:00:00	QQQ	ETF	36.56	36.59	36.51	36.55	51546.0
2009-07-01 07:30:00	QQQ	ETF	36.56	36.61	36.56	36.61	133684.0
2009-07-01 08:00:00	QQQ	ETF	36.61	36.61	36.45	36.58	854986.0
2009-07-01 08:30:00	QQQ	ETF	36.58	36.66	36.38	36.61	2990588.0
2009-07-01 09:00:00	QQQ	ETF	36.6	36.65	36.54	36.54	546459.0
2009-07-01 09:30:00	QQQ	ETF	36.54	36.69	36.5	36.68	10470895.0
2009-07-01 10:00:00	QQQ	ETF	36.67	36.84	36.52	36.83	13420282.0
2009-07-01 10:30:00	QQQ	ETF	36.83	36.84	36.74	36.7775	4665501.0
2009-07-01 11:00:00	QQQ	ETF	36.77	36.8	36.7	36.7201	4316012.0
2009-07-01 11:30:00	QQQ	ETF	36.71	36.79	36.7	36.77	3905465.0
2009-07-01 12:00:00	QQQ	ETF	36.77	36.79	36.7	36.77	3573995.0
2009-07-01 12:30:00	QQQ	ETF	36.77	36.77	36.65	36.6599	1821506.0
2009-07-01 13:00:00	QQQ	ETF	36.65	36.71	36.63	36.7095	3254128.0
2009-07-01 13:30:00	QQQ	ETF	36.7	36.71	36.64	36.65	3232105.0
2009-07-01 14:00:00	QQQ	ETF	36.6499	36.66	36.52	36.56	4948135.0

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

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