PREVIEW / etf_30min / 2008-01-04

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-04.parquet
  size:    157 KB
  rows:    5,684

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-04 06:30:00	SPY	ETF	145.31	145.33	145.22	145.28	35000.0
2008-01-04 07:00:00	SPY	ETF	145.28	145.28	145.0	145.17	319800.0
2008-01-04 07:30:00	SPY	ETF	145.18	145.23	145.15	145.19	233800.0
2008-01-04 08:00:00	SPY	ETF	145.2	145.34	144.92	145.22	1809400.0
2008-01-04 08:30:00	SPY	ETF	145.22	145.22	143.28	143.38	13975700.0
2008-01-04 09:00:00	SPY	ETF	143.4	143.43	143.1	143.34	3081855.0
2008-01-04 09:30:00	SPY	ETF	143.34	143.44	142.66	142.96	24459487.0
2008-01-04 10:00:00	SPY	ETF	142.9584	143.17	142.28	142.36	16091033.0
2008-01-04 10:30:00	SPY	ETF	142.36	142.6	141.84	141.93	13001192.0
2008-01-04 11:00:00	SPY	ETF	141.92	143.0	141.72	142.38	19426911.0
2008-01-04 11:30:00	SPY	ETF	142.38	142.46	142.06	142.31	15041177.0
2008-01-04 12:00:00	SPY	ETF	142.31	142.7	142.09	142.14	11014690.0
2008-01-04 12:30:00	SPY	ETF	142.14	142.55	141.9	142.13	9435038.0
2008-01-04 13:00:00	SPY	ETF	142.12	142.21	141.78	141.97	8630148.0
2008-01-04 13:30:00	SPY	ETF	141.97	142.18	141.5	142.01	9791905.0
2008-01-04 14:00:00	SPY	ETF	142.01	142.01	141.31	141.33	10905304.0
2008-01-04 14:30:00	SPY	ETF	141.33	141.58	140.99	141.48	13509611.0
2008-01-04 15:00:00	SPY	ETF	141.48	141.75	141.15	141.59	16692395.0
2008-01-04 15:30:00	SPY	ETF	141.58	142.0	140.92	140.93	26878073.0
2008-01-04 16:00:00	SPY	ETF	140.92	144.51	140.9099	144.51	11269200.0
2008-01-04 16:30:00	SPY	ETF	141.32	141.47	141.31	141.38	124000.0
2008-01-04 17:00:00	SPY	ETF	141.4	141.45	141.28	141.31	86600.0
2008-01-04 17:30:00	SPY	ETF	141.3	141.32	141.18	141.25	15200.0
2008-01-04 18:00:00	SPY	ETF	141.18	141.33	141.18	141.3	10500.0
2008-01-04 18:30:00	SPY	ETF	141.3	141.3	141.3	141.3	1300.0
2008-01-04 19:00:00	SPY	ETF	141.25	141.3	141.23	141.24	5200.0
2008-01-04 19:30:00	SPY	ETF	141.24	141.3	141.23	141.3	4200.0
2008-01-04 06:30:00	QQQ	ETF	50.65	50.65	50.64	50.64	10000.0
2008-01-04 07:00:00	QQQ	ETF	50.68	50.68	50.53	50.59	300308.0
2008-01-04 07:30:00	QQQ	ETF	50.61	50.61	50.55	50.57	128522.0
2008-01-04 08:00:00	QQQ	ETF	50.59	50.61	50.42	50.49	1947519.0
2008-01-04 08:30:00	QQQ	ETF	50.47	50.48	49.8	49.81	5712505.0
2008-01-04 09:00:00	QQQ	ETF	49.81	49.83	49.65	49.78	1749092.0
2008-01-04 09:30:00	QQQ	ETF	49.79	49.83	49.53	49.61	19206507.0
2008-01-04 10:00:00	QQQ	ETF	49.61	49.72	49.27	49.31	14636399.0
2008-01-04 10:30:00	QQQ	ETF	49.31	49.32	48.87	48.93	21096425.0
2008-01-04 11:00:00	QQQ	ETF	48.92	49.2	48.86	49.2	16410011.0
2008-01-04 11:30:00	QQQ	ETF	49.1901	49.24	49.09	49.1499	7851649.0
2008-01-04 12:00:00	QQQ	ETF	49.14	49.35	49.1	49.12	9369853.0
2008-01-04 12:30:00	QQQ	ETF	49.12	49.19	49.01	49.08	7618353.0
2008-01-04 13:00:00	QQQ	ETF	49.07	49.12	48.92	48.9826	5975077.0
2008-01-04 13:30:00	QQQ	ETF	48.98	49.1	48.76	49.02	13765673.0
2008-01-04 14:00:00	QQQ	ETF	49.02	49.028	48.62	48.64	11161225.0
2008-01-04 14:30:00	QQQ	ETF	48.64	48.66	48.31	48.5799	20003677.0
2008-01-04 15:00:00	QQQ	ETF	48.57	48.69	48.39	48.6	18452890.0
2008-01-04 15:30:00	QQQ	ETF	48.6	48.69	48.25	48.28	27689740.0
2008-01-04 16:00:00	QQQ	ETF	48.28	49.6	48.21	48.47	9226081.0
2008-01-04 16:30:00	QQQ	ETF	48.47	48.51	48.4	48.49	162523.0
2008-01-04 17:00:00	QQQ	ETF	48.47	48.55	48.47	48.52	79479.0
2008-01-04 17:30:00	QQQ	ETF	48.52	48.55	48.48	48.48	24381.0

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

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