PREVIEW / etf_30min / 2008-03-14

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-14.parquet
  size:    164 KB
  rows:    5,893

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-03-14 04:00:00	SPY	ETF	130.89	130.89	130.82	130.86	3200.0
2008-03-14 04:30:00	SPY	ETF	130.93	131.28	130.93	131.28	2100.0
2008-03-14 05:00:00	SPY	ETF	131.24	131.4	131.24	131.4	1000.0
2008-03-14 05:30:00	SPY	ETF	131.46	131.46	131.46	131.46	10000.0
2008-03-14 06:00:00	SPY	ETF	131.5	131.53	131.49	131.53	10500.0
2008-03-14 06:30:00	SPY	ETF	131.6	131.61	131.32	131.36	38700.0
2008-03-14 07:00:00	SPY	ETF	131.31	131.31	130.82	130.89	327100.0
2008-03-14 07:30:00	SPY	ETF	130.88	131.09	130.65	131.0	831900.0
2008-03-14 08:00:00	SPY	ETF	131.01	131.19	130.67	131.06	2625600.0
2008-03-14 08:30:00	SPY	ETF	131.06	132.93	131.06	132.63	16570600.0
2008-03-14 09:00:00	SPY	ETF	132.63	133.76	131.33	132.78	16455818.0
2008-03-14 09:30:00	SPY	ETF	132.77	132.81	129.42	129.43	62603090.0
2008-03-14 10:00:00	SPY	ETF	129.44	131.0	128.0	129.89	76098053.0
2008-03-14 10:30:00	SPY	ETF	129.9	130.37	128.68	129.99	32232684.0
2008-03-14 11:00:00	SPY	ETF	130.01	130.3	129.2	129.49	20073057.0
2008-03-14 11:30:00	SPY	ETF	129.49	130.5	129.27	129.68	17721257.0
2008-03-14 12:00:00	SPY	ETF	129.68	130.11	129.51	129.75	13432421.0
2008-03-14 12:30:00	SPY	ETF	129.74	129.97	128.97	129.38	20704647.0
2008-03-14 13:00:00	SPY	ETF	129.39	129.42	128.73	128.96	17969019.0
2008-03-14 13:30:00	SPY	ETF	128.96	129.46	128.7	128.84	15221195.0
2008-03-14 14:00:00	SPY	ETF	128.8	129.08	127.95	128.15	25184006.0
2008-03-14 14:30:00	SPY	ETF	128.14	129.0	127.78	128.5	34580981.0
2008-03-14 15:00:00	SPY	ETF	128.5	130.35	128.2	129.94	37694419.0
2008-03-14 15:30:00	SPY	ETF	129.95	132.0	128.7	129.251	46540876.0
2008-03-14 16:00:00	SPY	ETF	129.289	129.67	128.78	129.62	9778500.0
2008-03-14 16:30:00	SPY	ETF	129.62	129.9	129.57	129.65	3806800.0
2008-03-14 17:00:00	SPY	ETF	129.7	131.9624	129.49	129.5	3773600.0
2008-03-14 17:30:00	SPY	ETF	129.49	129.5	129.4	129.5	34300.0
2008-03-14 18:00:00	SPY	ETF	129.52	129.8	129.52	129.8	58900.0
2008-03-14 18:30:00	SPY	ETF	129.8	129.81	129.74	129.77	13900.0
2008-03-14 19:00:00	SPY	ETF	129.75	129.76	129.65	129.65	8300.0
2008-03-14 19:30:00	SPY	ETF	129.65	129.67	129.6	129.6	4300.0
2008-03-14 04:00:00	QQQ	ETF	42.82	42.82	42.8	42.8	200.0
2008-03-14 05:00:00	QQQ	ETF	42.92	42.92	42.92	42.92	200.0
2008-03-14 07:00:00	QQQ	ETF	42.92	42.93	42.82	42.85	130107.0
2008-03-14 07:30:00	QQQ	ETF	42.81	42.84	42.72	42.83	700951.0
2008-03-14 08:00:00	QQQ	ETF	42.84	43.03	42.8	42.92	2339379.0
2008-03-14 08:30:00	QQQ	ETF	42.87	43.64	42.87	43.47	7748559.0
2008-03-14 09:00:00	QQQ	ETF	43.49	43.68	42.8392	43.36	5705290.0
2008-03-14 09:30:00	QQQ	ETF	43.36	43.38	42.24	42.25	40206798.0
2008-03-14 10:00:00	QQQ	ETF	42.25	42.8	41.81	42.4378	51174715.0
2008-03-14 10:30:00	QQQ	ETF	42.44	42.599	42.08	42.49	20627633.0
2008-03-14 11:00:00	QQQ	ETF	42.48	42.61	42.15	42.25	19215151.0
2008-03-14 11:30:00	QQQ	ETF	42.24	42.58	42.19	42.342	17611933.0
2008-03-14 12:00:00	QQQ	ETF	42.35	42.47	42.29	42.4	7161403.0
2008-03-14 12:30:00	QQQ	ETF	42.4	42.428	42.06	42.24	16596660.0
2008-03-14 13:00:00	QQQ	ETF	42.24	42.24	42.01	42.17	17558756.0
2008-03-14 13:30:00	QQQ	ETF	42.17	42.29	42.07	42.08	7762570.0
2008-03-14 14:00:00	QQQ	ETF	42.07	42.12	41.8	41.85	17884899.0
2008-03-14 14:30:00	QQQ	ETF	41.85	42.08	41.74	41.96	15205955.0

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

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