PREVIEW / etf_30min / 2009-01-26

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-26.parquet
  size:    203 KB
  rows:    6,642

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-01-26 04:00:00	SPY	ETF	82.86	82.86	82.61	82.61	3170.0
2009-01-26 04:30:00	SPY	ETF	82.55	82.56	82.55	82.56	200.0
2009-01-26 05:00:00	SPY	ETF	82.91	82.91	82.91	82.91	1000.0
2009-01-26 05:30:00	SPY	ETF	83.29	83.29	83.17	83.17	800.0
2009-01-26 06:00:00	SPY	ETF	83.02	83.18	83.0	83.15	55200.0
2009-01-26 06:30:00	SPY	ETF	83.14	83.28	83.1	83.23	25200.0
2009-01-26 07:00:00	SPY	ETF	83.28	83.39	83.09	83.22	606223.0
2009-01-26 07:30:00	SPY	ETF	83.24	83.27	82.55	82.91	1363735.0
2009-01-26 08:00:00	SPY	ETF	82.91	83.23	82.6	82.9	1236214.0
2009-01-26 08:30:00	SPY	ETF	82.92	83.69	82.9	83.41	2234376.0
2009-01-26 09:00:00	SPY	ETF	83.41	83.77	82.1	83.58	2035522.0
2009-01-26 09:30:00	SPY	ETF	83.59	84.61	83.43	84.33	33441340.0
2009-01-26 10:00:00	SPY	ETF	84.33	85.36	84.32	85.08	33036696.0
2009-01-26 10:30:00	SPY	ETF	85.09	85.2	84.71	84.92	14934961.0
2009-01-26 11:00:00	SPY	ETF	84.93	85.25	84.46	84.68	16150354.0
2009-01-26 11:30:00	SPY	ETF	84.68	84.83	84.26	84.52	15096503.0
2009-01-26 12:00:00	SPY	ETF	84.52	84.87	84.37	84.73	14720444.0
2009-01-26 12:30:00	SPY	ETF	84.73	84.86	84.31	84.51	18229126.0
2009-01-26 13:00:00	SPY	ETF	84.52	84.74	84.08	84.37	18978920.0
2009-01-26 13:30:00	SPY	ETF	84.37	84.3825	83.5	83.67	20158939.0
2009-01-26 14:00:00	SPY	ETF	83.67	83.7	82.81	83.18	28612425.0
2009-01-26 14:30:00	SPY	ETF	83.18	83.85	83.04	83.76	24958594.0
2009-01-26 15:00:00	SPY	ETF	83.74	84.45	83.72	84.17	24212055.0
2009-01-26 15:30:00	SPY	ETF	84.17	84.33	83.38	83.7	36323571.0
2009-01-26 16:00:00	SPY	ETF	83.67	84.448	83.46	83.7	4305955.0
2009-01-26 16:30:00	SPY	ETF	83.7	83.84	83.69	83.84	463045.0
2009-01-26 17:00:00	SPY	ETF	83.84	83.84	83.7	83.75	1601625.0
2009-01-26 17:30:00	SPY	ETF	84.7112	84.7112	83.69	83.75	73924.0
2009-01-26 18:00:00	SPY	ETF	83.75	84.04	83.74	83.92	139864.0
2009-01-26 18:30:00	SPY	ETF	83.92	83.96	83.8	83.93	72534.0
2009-01-26 19:00:00	SPY	ETF	83.93	84.03	83.87	84.0	43514.0
2009-01-26 19:30:00	SPY	ETF	83.98	84.01	83.88	83.99	60255.0
2009-01-26 04:00:00	QQQ	ETF	28.66	28.66	28.63	28.63	700.0
2009-01-26 04:30:00	QQQ	ETF	28.6	28.6	28.6	28.6	300.0
2009-01-26 05:00:00	QQQ	ETF	28.69	28.77	28.69	28.77	1000.0
2009-01-26 06:00:00	QQQ	ETF	28.82	28.86	28.82	28.86	400.0
2009-01-26 06:30:00	QQQ	ETF	28.88	28.88	28.88	28.88	500.0
2009-01-26 07:00:00	QQQ	ETF	28.84	28.87	28.8	28.85	373845.0
2009-01-26 07:30:00	QQQ	ETF	28.86	28.9	28.69	28.88	206929.0
2009-01-26 08:00:00	QQQ	ETF	28.9	28.9	28.8	28.82	151298.0
2009-01-26 08:30:00	QQQ	ETF	28.82	28.99	28.82	28.93	461640.0
2009-01-26 09:00:00	QQQ	ETF	28.92	28.99	28.9	28.95	765602.0
2009-01-26 09:30:00	QQQ	ETF	28.96	29.26	28.85	29.17	15905056.0
2009-01-26 10:00:00	QQQ	ETF	29.1799	29.59	29.17	29.52	11106675.0
2009-01-26 10:30:00	QQQ	ETF	29.52	29.5699	29.37	29.43	7721926.0
2009-01-26 11:00:00	QQQ	ETF	29.43	29.5	29.27	29.37	5509621.0
2009-01-26 11:30:00	QQQ	ETF	29.37	29.4	29.22	29.3	4806382.0
2009-01-26 12:00:00	QQQ	ETF	29.31	29.44	29.29	29.39	6407807.0
2009-01-26 12:30:00	QQQ	ETF	29.39	29.42	29.26	29.35	6801398.0
2009-01-26 13:00:00	QQQ	ETF	29.34	29.4	29.2	29.26	8121727.0

> showing 50 of 6,642 rows — these rows as CSV

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