PREVIEW / etf_30min / 2009-01-29

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-29.parquet
  size:    200 KB
  rows:    6,629

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-29 04:00:00	SPY	ETF	86.6	86.6	86.08	86.15	14950.0
2009-01-29 04:30:00	SPY	ETF	86.14	86.3	86.1	86.25	4850.0
2009-01-29 05:00:00	SPY	ETF	86.53	86.58	86.45	86.45	2300.0
2009-01-29 05:30:00	SPY	ETF	86.45	86.57	86.45	86.57	300.0
2009-01-29 06:00:00	SPY	ETF	86.67	86.68	86.39	86.45	22100.0
2009-01-29 06:30:00	SPY	ETF	86.47	86.56	86.31	86.52	40400.0
2009-01-29 07:00:00	SPY	ETF	86.7	86.9	86.7	86.84	250061.0
2009-01-29 07:30:00	SPY	ETF	86.82	87.03	86.62	86.63	515707.0
2009-01-29 08:00:00	SPY	ETF	86.64	86.7	86.4	86.49	1539579.0
2009-01-29 08:30:00	SPY	ETF	86.49	86.66	86.26	86.5	2931978.0
2009-01-29 09:00:00	SPY	ETF	86.49	86.51	86.09	86.12	2458533.0
2009-01-29 09:30:00	SPY	ETF	86.11	86.36	85.66	85.81	31850306.0
2009-01-29 10:00:00	SPY	ETF	85.82	86.04	85.47	85.98	25835215.0
2009-01-29 10:30:00	SPY	ETF	85.98	86.34	85.68	86.25	20396118.0
2009-01-29 11:00:00	SPY	ETF	86.25	86.31	85.85	85.85	14665718.0
2009-01-29 11:30:00	SPY	ETF	85.85	85.91	85.55	85.68	13325589.0
2009-01-29 12:00:00	SPY	ETF	85.68	85.69	85.33	85.64	13464776.0
2009-01-29 12:30:00	SPY	ETF	85.64	85.73	84.94	85.03	14708526.0
2009-01-29 13:00:00	SPY	ETF	85.03	85.25	84.84	85.1892	16667707.0
2009-01-29 13:30:00	SPY	ETF	85.19	86.15	84.71	84.935	18488392.0
2009-01-29 14:00:00	SPY	ETF	84.93	85.3418	84.85	85.29	18275746.0
2009-01-29 14:30:00	SPY	ETF	85.29	85.48	84.99	85.08	20877518.0
2009-01-29 15:00:00	SPY	ETF	85.08	87.4901	84.89	85.04	27691800.0
2009-01-29 15:30:00	SPY	ETF	85.03	85.09	84.47	84.57	34272109.0
2009-01-29 16:00:00	SPY	ETF	84.58	85.83	84.46	84.7	8996663.0
2009-01-29 16:30:00	SPY	ETF	84.69	84.86	84.65	84.74	5099270.0
2009-01-29 17:00:00	SPY	ETF	84.78	84.81	84.65	84.7	135516.0
2009-01-29 17:30:00	SPY	ETF	84.66	84.7	84.55	84.65	36365.0
2009-01-29 18:00:00	SPY	ETF	84.67	84.9	84.65	84.87	65832.0
2009-01-29 18:30:00	SPY	ETF	84.85	84.95	84.85	84.94	25540.0
2009-01-29 19:00:00	SPY	ETF	84.94	84.94	84.52	84.56	90108.0
2009-01-29 19:30:00	SPY	ETF	84.58	84.79	84.56	84.76	67236.0
2009-01-29 04:00:00	QQQ	ETF	30.0	30.0	30.0	30.0	1155.0
2009-01-29 04:30:00	QQQ	ETF	29.9	29.9	29.9	29.9	5100.0
2009-01-29 05:00:00	QQQ	ETF	29.99	29.99	29.99	29.99	500.0
2009-01-29 05:30:00	QQQ	ETF	30.09	30.09	30.09	30.09	100.0
2009-01-29 06:00:00	QQQ	ETF	30.0	30.0	30.0	30.0	10300.0
2009-01-29 07:00:00	QQQ	ETF	30.07	30.13	30.07	30.13	7853.0
2009-01-29 07:30:00	QQQ	ETF	30.16	30.24	30.13	30.13	162130.0
2009-01-29 08:00:00	QQQ	ETF	30.12	30.14	29.92	30.09	554635.0
2009-01-29 08:30:00	QQQ	ETF	30.06	30.11	29.99	30.06	1071358.0
2009-01-29 09:00:00	QQQ	ETF	30.05	30.05	29.95	29.97	606331.0
2009-01-29 09:30:00	QQQ	ETF	29.97	30.05	29.8	29.87	18281791.0
2009-01-29 10:00:00	QQQ	ETF	29.86	29.92	29.76	29.88	16793229.0
2009-01-29 10:30:00	QQQ	ETF	29.88	30.04	29.79	30.01	9287802.0
2009-01-29 11:00:00	QQQ	ETF	30.0	30.03	29.89	29.89	7313986.0
2009-01-29 11:30:00	QQQ	ETF	29.89	29.94	29.83	29.88	4527095.0
2009-01-29 12:00:00	QQQ	ETF	29.8779	29.8779	29.75	29.87	4958057.0
2009-01-29 12:30:00	QQQ	ETF	29.86	29.89	29.59	29.61	8252408.0
2009-01-29 13:00:00	QQQ	ETF	29.61	29.66	29.48	29.64	7514818.0

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

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