PREVIEW / etf_30min / 2008-01-18

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-18.parquet
  size:    163 KB
  rows:    5,846

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
2008-01-18 04:00:00	SPY	ETF	134.02	134.34	134.01	134.34	14500.0
2008-01-18 04:30:00	SPY	ETF	134.24	134.49	134.18	134.4	6800.0
2008-01-18 05:00:00	SPY	ETF	134.5	134.76	134.5	134.76	2100.0
2008-01-18 05:30:00	SPY	ETF	134.9	135.16	134.78	134.78	22100.0
2008-01-18 06:00:00	SPY	ETF	134.81	134.83	134.63	134.76	51000.0
2008-01-18 06:30:00	SPY	ETF	134.88	135.2	134.86	135.1	431600.0
2008-01-18 07:00:00	SPY	ETF	135.1	135.17	134.84	134.85	706100.0
2008-01-18 07:30:00	SPY	ETF	134.85	135.5	134.69	135.36	1320700.0
2008-01-18 08:00:00	SPY	ETF	135.36	135.51	133.95	135.25	3568197.0
2008-01-18 08:30:00	SPY	ETF	135.25	135.42	134.91	135.04	1382600.0
2008-01-18 09:00:00	SPY	ETF	135.03	135.04	134.03	134.2	4425646.0
2008-01-18 09:30:00	SPY	ETF	134.19	135.0	133.61	133.73	43907230.0
2008-01-18 10:00:00	SPY	ETF	133.74	135.02	133.56	134.52	27313169.0
2008-01-18 10:30:00	SPY	ETF	134.53	134.63	133.5	133.67	24711354.0
2008-01-18 11:00:00	SPY	ETF	133.67	133.77	132.16	132.71	30680342.0
2008-01-18 11:30:00	SPY	ETF	132.71	132.92	131.1	131.43	34523828.0
2008-01-18 12:00:00	SPY	ETF	131.42	132.5	131.34	132.5	24871800.0
2008-01-18 12:30:00	SPY	ETF	132.5	133.31	132.1	132.39	17156256.0
2008-01-18 13:00:00	SPY	ETF	132.38	132.89	131.6	131.9499	16026938.0
2008-01-18 13:30:00	SPY	ETF	131.94	132.48	131.7	132.01	13770464.0
2008-01-18 14:00:00	SPY	ETF	132.01	132.61	131.76	132.04	16454503.0
2008-01-18 14:30:00	SPY	ETF	132.03	132.1	131.4	132.0	19350284.0
2008-01-18 15:00:00	SPY	ETF	132.0	132.6	131.57	131.74	25111538.0
2008-01-18 15:30:00	SPY	ETF	131.75	132.73	131.71	132.49	29655460.0
2008-01-18 16:00:00	SPY	ETF	132.53	132.62	132.01	132.13	4673400.0
2008-01-18 16:30:00	SPY	ETF	132.18	135.36	132.12	132.13	3103200.0
2008-01-18 17:00:00	SPY	ETF	132.11	134.72	132.08	132.08	95000.0
2008-01-18 17:30:00	SPY	ETF	132.15	132.15	132.02	132.05	66900.0
2008-01-18 18:00:00	SPY	ETF	132.05	132.05	131.9	131.93	78100.0
2008-01-18 18:30:00	SPY	ETF	131.9	131.9	131.73	131.9	23500.0
2008-01-18 19:00:00	SPY	ETF	131.8	131.9	131.75	131.75	7900.0
2008-01-18 19:30:00	SPY	ETF	131.75	131.8	131.65	131.7	26400.0
2008-01-18 20:00:00	SPY	ETF	131.7	131.7	131.7	131.7	300.0
2008-01-18 04:00:00	QQQ	ETF	45.61	45.61	45.61	45.61	200.0
2008-01-18 04:30:00	QQQ	ETF	45.72	45.72	45.72	45.72	2000.0
2008-01-18 05:00:00	QQQ	ETF	45.74	45.8	45.74	45.8	5300.0
2008-01-18 05:30:00	QQQ	ETF	45.84	45.87	45.79	45.79	2400.0
2008-01-18 06:00:00	QQQ	ETF	45.81	45.82	45.78	45.78	6100.0
2008-01-18 06:30:00	QQQ	ETF	45.82	45.93	45.82	45.93	15400.0
2008-01-18 07:00:00	QQQ	ETF	45.93	45.95	45.8	45.8	175195.0
2008-01-18 07:30:00	QQQ	ETF	45.81	46.03	45.76	46.0	559999.0
2008-01-18 08:00:00	QQQ	ETF	46.0	46.07	45.65	45.94	1322064.0
2008-01-18 08:30:00	QQQ	ETF	45.96	46.01	45.83	45.95	957335.0
2008-01-18 09:00:00	QQQ	ETF	45.94	45.95	45.55	45.64	4136475.0
2008-01-18 09:30:00	QQQ	ETF	45.64	45.85	45.43	45.66	23987409.0
2008-01-18 10:00:00	QQQ	ETF	45.66	46.14	45.62	46.04	25270413.0
2008-01-18 10:30:00	QQQ	ETF	46.04	46.06	45.7	45.76	13186526.0
2008-01-18 11:00:00	QQQ	ETF	45.76	45.81	45.34	45.5199	20523330.0
2008-01-18 11:30:00	QQQ	ETF	45.52	45.7	44.76	45.1	32087610.0
2008-01-18 12:00:00	QQQ	ETF	45.11	45.69	45.08	45.64	21179814.0

> showing 50 of 5,846 rows — these rows as CSV

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