PREVIEW / etf_30min / 2006-03-28

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-03-28.parquet
  size:    63 KB
  rows:    2,234

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
2006-03-28 07:00:00	SPY	ETF	130.15	130.15	130.05	130.05	3500.0
2006-03-28 07:30:00	SPY	ETF	130.0	130.03	129.98	129.98	8800.0
2006-03-28 08:00:00	SPY	ETF	130.0	130.15	129.98	130.12	52300.0
2006-03-28 08:30:00	SPY	ETF	130.11	130.12	129.91	129.92	467400.0
2006-03-28 09:00:00	SPY	ETF	129.93	130.04	129.925	129.95	320900.0
2006-03-28 09:30:00	SPY	ETF	129.93	130.12	129.88	130.02	3933900.0
2006-03-28 10:00:00	SPY	ETF	130.02	130.09	129.88	130.06	3970300.0
2006-03-28 10:30:00	SPY	ETF	130.06	130.07	129.9	129.98	1812100.0
2006-03-28 11:00:00	SPY	ETF	129.98	130.02	129.89	129.99	2200200.0
2006-03-28 11:30:00	SPY	ETF	129.99	130.08	129.97	130.06	875900.0
2006-03-28 12:00:00	SPY	ETF	130.05	130.44	130.0412	130.39	4817400.0
2006-03-28 12:30:00	SPY	ETF	130.4	130.53	130.39	130.43	2713700.0
2006-03-28 13:00:00	SPY	ETF	130.45	130.45	130.31	130.4	1907600.0
2006-03-28 13:30:00	SPY	ETF	130.4	130.4	130.23	130.33	1432600.0
2006-03-28 14:00:00	SPY	ETF	130.33	130.44	129.5	129.68	13843000.0
2006-03-28 14:30:00	SPY	ETF	129.68	129.95	129.35	129.56	15337600.0
2006-03-28 15:00:00	SPY	ETF	129.56	129.75	129.08	129.25	13016900.0
2006-03-28 15:30:00	SPY	ETF	129.25	129.34	129.05	129.22	9282900.0
2006-03-28 16:00:00	SPY	ETF	129.22	130.1019	129.18	129.25	1825900.0
2006-03-28 16:30:00	SPY	ETF	129.25	129.26	129.17	129.19	323800.0
2006-03-28 17:00:00	SPY	ETF	129.19	129.19	129.14	129.14	11100.0
2006-03-28 17:30:00	SPY	ETF	129.16	129.22	129.14	129.15	8300.0
2006-03-28 18:00:00	SPY	ETF	129.13	129.18	129.1	129.11	5500.0
2006-03-28 18:30:00	SPY	ETF	129.15	129.15	129.15	129.15	1000.0
2006-03-28 19:00:00	SPY	ETF	129.19	129.19	129.19	129.19	100.0
2006-03-28 19:30:00	SPY	ETF	129.2	129.2	129.17	129.17	6200.0
2006-03-28 09:30:00	QQQ	ETF	41.37	41.47	41.33	41.41	5964000.0
2006-03-28 10:00:00	QQQ	ETF	41.41	41.49	41.34	41.46	7707800.0
2006-03-28 10:30:00	QQQ	ETF	41.46	41.46	41.4	41.44	3771900.0
2006-03-28 11:00:00	QQQ	ETF	41.44	41.46	41.4	41.44	1562500.0
2006-03-28 11:30:00	QQQ	ETF	41.44	41.47	41.42	41.44	2169100.0
2006-03-28 12:00:00	QQQ	ETF	41.44	41.62	41.43	41.59	5044200.0
2006-03-28 12:30:00	QQQ	ETF	41.6	41.67	41.58	41.58	5737200.0
2006-03-28 13:00:00	QQQ	ETF	41.58	41.59	41.53	41.56	1715600.0
2006-03-28 13:30:00	QQQ	ETF	41.57	41.57	41.45	41.53	2597500.0
2006-03-28 14:00:00	QQQ	ETF	41.54	41.59	41.28	41.33	14176000.0
2006-03-28 14:30:00	QQQ	ETF	41.34	41.34	41.18	41.23	13133100.0
2006-03-28 15:00:00	QQQ	ETF	41.24	41.25	40.99	41.09	17586900.0
2006-03-28 15:30:00	QQQ	ETF	41.09	41.15	41.0	41.13	14853000.0
2006-03-28 08:00:00	IWM	ETF	75.35	75.35	74.79	74.8	500.0
2006-03-28 08:30:00	IWM	ETF	74.81	74.81	74.74	74.76	3000.0
2006-03-28 09:00:00	IWM	ETF	74.78	74.79	74.74	74.79	37500.0
2006-03-28 09:30:00	IWM	ETF	74.81	74.89	74.74	74.77	799800.0
2006-03-28 10:00:00	IWM	ETF	74.77	74.88	74.71	74.87	2300100.0
2006-03-28 10:30:00	IWM	ETF	74.86	74.95	74.82	74.89	808100.0
2006-03-28 11:00:00	IWM	ETF	74.89	74.95	74.84	74.95	1238400.0
2006-03-28 11:30:00	IWM	ETF	74.95	75.02	74.91	74.99	755200.0
2006-03-28 12:00:00	IWM	ETF	74.99	75.24	74.99	75.21	2130900.0
2006-03-28 12:30:00	IWM	ETF	75.21	75.3	75.19	75.22	1710200.0
2006-03-28 13:00:00	IWM	ETF	75.22	75.24	75.15	75.19	1229600.0

> showing 50 of 2,234 rows — these rows as CSV

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