PREVIEW / etf_30min / 2009-08-06

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-06.parquet
  size:    229 KB
  rows:    7,561

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-08-06 04:00:00	SPY	ETF	100.63	100.71	100.63	100.71	2100.0
2009-08-06 04:30:00	SPY	ETF	100.62	100.72	100.46	100.6	16750.0
2009-08-06 05:00:00	SPY	ETF	100.62	100.62	100.48	100.51	6200.0
2009-08-06 05:30:00	SPY	ETF	100.41	100.41	100.4	100.4	3000.0
2009-08-06 06:00:00	SPY	ETF	100.6	100.62	100.58	100.59	10800.0
2009-08-06 06:30:00	SPY	ETF	100.6	100.6	100.41	100.45	4600.0
2009-08-06 07:00:00	SPY	ETF	100.43	100.78	100.43	100.68	66345.0
2009-08-06 07:30:00	SPY	ETF	100.7	100.95	100.66	100.87	231717.0
2009-08-06 08:00:00	SPY	ETF	100.86	101.1	100.55	100.96	1827959.0
2009-08-06 08:30:00	SPY	ETF	100.96	101.35	100.58	100.88	2317422.0
2009-08-06 09:00:00	SPY	ETF	100.88	100.95	100.83	100.87	1996158.0
2009-08-06 09:30:00	SPY	ETF	100.87	101.02	100.15	100.22	28235162.0
2009-08-06 10:00:00	SPY	ETF	100.21	100.26	99.7	99.86	21380550.0
2009-08-06 10:30:00	SPY	ETF	99.86	100.21	99.81	100.0601	13083171.0
2009-08-06 11:00:00	SPY	ETF	100.07	100.35	100.04	100.265	8952095.0
2009-08-06 11:30:00	SPY	ETF	100.23	100.258	100.03	100.08	8005879.0
2009-08-06 12:00:00	SPY	ETF	100.08	100.09	99.73	99.8001	12319248.0
2009-08-06 12:30:00	SPY	ETF	99.81	100.06	99.76	99.85	8233889.0
2009-08-06 13:00:00	SPY	ETF	99.8501	100.1	99.78	100.02	6619904.0
2009-08-06 13:30:00	SPY	ETF	100.01	100.22	99.79	99.82	8949973.0
2009-08-06 14:00:00	SPY	ETF	99.82	99.92	99.42	99.65	20366222.0
2009-08-06 14:30:00	SPY	ETF	99.65	99.78	99.4887	99.64	8354762.0
2009-08-06 15:00:00	SPY	ETF	99.64	100.07	99.6	99.96	8782961.0
2009-08-06 15:30:00	SPY	ETF	99.96	100.03	99.75	99.88	21287114.0
2009-08-06 16:00:00	SPY	ETF	99.89	100.4571	99.7186	99.92	8574150.0
2009-08-06 16:30:00	SPY	ETF	99.92	100.0	99.89	99.91	3231897.0
2009-08-06 17:00:00	SPY	ETF	99.9	99.9	99.84	99.89	194839.0
2009-08-06 17:30:00	SPY	ETF	99.89	99.89	99.84	99.85	18180.0
2009-08-06 18:00:00	SPY	ETF	99.85	99.93	99.85	99.89	40460.0
2009-08-06 18:30:00	SPY	ETF	99.89	99.93	99.82	99.85	17991.0
2009-08-06 19:00:00	SPY	ETF	99.85	99.93	99.85	99.89	75251.0
2009-08-06 19:30:00	SPY	ETF	99.9	99.94	99.88	99.92	25404.0
2009-08-06 04:30:00	QQQ	ETF	39.71	39.74	39.71	39.74	2859.0
2009-08-06 05:00:00	QQQ	ETF	39.63	39.66	39.63	39.66	383.0
2009-08-06 05:30:00	QQQ	ETF	39.71	39.71	39.67	39.67	1200.0
2009-08-06 06:30:00	QQQ	ETF	39.7	39.7	39.61	39.62	34100.0
2009-08-06 07:00:00	QQQ	ETF	39.59	39.79	39.59	39.69	442848.0
2009-08-06 07:30:00	QQQ	ETF	39.7	39.8	39.7	39.76	138250.0
2009-08-06 08:00:00	QQQ	ETF	39.76	39.89	39.67	39.84	1221184.0
2009-08-06 08:30:00	QQQ	ETF	39.84	39.96	39.68	39.85	1421602.0
2009-08-06 09:00:00	QQQ	ETF	39.85	39.86	39.78	39.79	1964824.0
2009-08-06 09:30:00	QQQ	ETF	39.79	39.93	39.47	39.48	16502054.0
2009-08-06 10:00:00	QQQ	ETF	39.48	39.54	39.35	39.4	11899076.0
2009-08-06 10:30:00	QQQ	ETF	39.41	39.55	39.38	39.4501	10226689.0
2009-08-06 11:00:00	QQQ	ETF	39.4501	39.65	39.45	39.57	10162308.0
2009-08-06 11:30:00	QQQ	ETF	39.58	39.59	39.44	39.4401	4017081.0
2009-08-06 12:00:00	QQQ	ETF	39.45	39.46	39.31	39.36	5329510.0
2009-08-06 12:30:00	QQQ	ETF	39.35	39.5	39.34	39.399	4109985.0
2009-08-06 13:00:00	QQQ	ETF	39.4	39.53	39.36	39.4811	2293962.0
2009-08-06 13:30:00	QQQ	ETF	39.49	39.57	39.38	39.41	3229339.0

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

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