PREVIEW / etf_30min / 2007-03-16

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-16.parquet
  size:    104 KB
  rows:    3,597

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
2007-03-16 04:00:00	SPY	ETF	138.71	138.71	138.65	138.65	700.0
2007-03-16 06:00:00	SPY	ETF	138.81	138.81	138.69	138.69	6600.0
2007-03-16 06:30:00	SPY	ETF	138.67	138.81	138.65	138.81	25800.0
2007-03-16 07:00:00	SPY	ETF	138.79	138.82	138.65	138.8	253200.0
2007-03-16 07:30:00	SPY	ETF	138.78	138.78	138.58	138.64	253000.0
2007-03-16 08:00:00	SPY	ETF	138.68	138.81	138.35	138.6	1836600.0
2007-03-16 08:30:00	SPY	ETF	138.6	139.13	138.5	138.95	6881800.0
2007-03-16 09:00:00	SPY	ETF	138.95	139.44	138.95	139.31	2894200.0
2007-03-16 09:30:00	SPY	ETF	139.31	139.53	138.87	139.43	15876315.0
2007-03-16 10:00:00	SPY	ETF	139.43	139.63	139.29	139.49	8759880.0
2007-03-16 10:30:00	SPY	ETF	139.47	139.53	139.08	139.09	8684807.0
2007-03-16 11:00:00	SPY	ETF	139.09	139.16	138.77	138.82	11187300.0
2007-03-16 11:30:00	SPY	ETF	138.82	138.87	138.53	138.7	9439200.0
2007-03-16 12:00:00	SPY	ETF	138.7	138.85	138.64	138.76	2782152.0
2007-03-16 12:30:00	SPY	ETF	138.76	138.81	138.64	138.74	2317700.0
2007-03-16 13:00:00	SPY	ETF	138.73	138.98	138.59	138.85	3762700.0
2007-03-16 13:30:00	SPY	ETF	138.85	139.0	138.63	138.71	3873454.0
2007-03-16 14:00:00	SPY	ETF	138.72	138.72	138.12	138.45	7854000.0
2007-03-16 14:30:00	SPY	ETF	138.45	138.47	138.2	138.45	6801950.0
2007-03-16 15:00:00	SPY	ETF	138.45	138.56	138.3	138.55	6461100.0
2007-03-16 15:30:00	SPY	ETF	138.55	138.7	138.48	138.48	13086450.0
2007-03-16 16:00:00	SPY	ETF	138.49	138.61	138.42	138.55	2653200.0
2007-03-16 16:30:00	SPY	ETF	138.55	138.55	138.39	138.4	2508000.0
2007-03-16 17:00:00	SPY	ETF	138.4	138.45	138.1	138.1	156300.0
2007-03-16 17:30:00	SPY	ETF	138.1	138.15	137.95	138.05	907400.0
2007-03-16 18:00:00	SPY	ETF	138.05	138.54	138.0	138.12	525300.0
2007-03-16 18:30:00	SPY	ETF	138.15	138.19	138.14	138.19	7900.0
2007-03-16 19:00:00	SPY	ETF	138.15	138.19	138.15	138.17	3400.0
2007-03-16 19:30:00	SPY	ETF	138.16	138.23	138.16	138.2	22000.0
2007-03-16 04:00:00	QQQ	ETF	42.77	42.77	42.77	42.77	2500.0
2007-03-16 07:00:00	QQQ	ETF	42.77	42.78	42.76	42.78	11900.0
2007-03-16 07:30:00	QQQ	ETF	42.77	42.77	42.69	42.72	37456.0
2007-03-16 08:00:00	QQQ	ETF	42.73	42.76	42.68	42.7	631769.0
2007-03-16 08:30:00	QQQ	ETF	42.71	42.9	42.68	42.82	2074667.0
2007-03-16 09:00:00	QQQ	ETF	42.83	43.0	42.82	42.95	1513515.0
2007-03-16 09:30:00	QQQ	ETF	42.95	43.0	42.78	42.92	11784800.0
2007-03-16 10:00:00	QQQ	ETF	42.92	43.04	42.89	42.98	10683900.0
2007-03-16 10:30:00	QQQ	ETF	42.98	42.99	42.83	42.84	6794900.0
2007-03-16 11:00:00	QQQ	ETF	42.84	42.86	42.66	42.7	12225600.0
2007-03-16 11:30:00	QQQ	ETF	42.71	42.72	42.61	42.7	7542000.0
2007-03-16 12:00:00	QQQ	ETF	42.7	42.82	42.7	42.77	4241200.0
2007-03-16 12:30:00	QQQ	ETF	42.77	42.82	42.72	42.79	3258400.0
2007-03-16 13:00:00	QQQ	ETF	42.79	42.89	42.75	42.85	4119700.0
2007-03-16 13:30:00	QQQ	ETF	42.85	42.91	42.81	42.86	4951700.0
2007-03-16 14:00:00	QQQ	ETF	42.87	42.87	42.67	42.75	6725400.0
2007-03-16 14:30:00	QQQ	ETF	42.75	42.8	42.68	42.77	5009200.0
2007-03-16 15:00:00	QQQ	ETF	42.76	42.83	42.74	42.83	10078100.0
2007-03-16 15:30:00	QQQ	ETF	42.84	42.87	42.78	42.83	9301000.0
2007-03-16 16:00:00	QQQ	ETF	42.83	42.87	42.82	42.87	2618471.0
2007-03-16 16:30:00	QQQ	ETF	42.87	42.87	42.84	42.84	33285.0

> showing 50 of 3,597 rows — these rows as CSV

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