PREVIEW / etf_30min / 2007-03-15

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-15.parquet
  size:    100 KB
  rows:    3,516

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-15 06:30:00	SPY	ETF	139.4	139.4	139.4	139.4	5000.0
2007-03-15 07:00:00	SPY	ETF	139.48	139.62	139.4	139.6	268900.0
2007-03-15 07:30:00	SPY	ETF	139.5	139.7	139.5	139.67	203000.0
2007-03-15 08:00:00	SPY	ETF	139.67	139.82	139.57	139.82	2416300.0
2007-03-15 08:30:00	SPY	ETF	139.73	139.77	139.01	139.16	7639100.0
2007-03-15 09:00:00	SPY	ETF	139.17	139.27	138.86	139.04	3361000.0
2007-03-15 09:30:00	SPY	ETF	139.06	139.61	138.8	139.57	17303800.0
2007-03-15 10:00:00	SPY	ETF	139.58	139.72	139.33	139.71	11260500.0
2007-03-15 10:30:00	SPY	ETF	139.72	139.99	139.6	139.73	16260300.0
2007-03-15 11:00:00	SPY	ETF	139.72	139.84	139.52	139.79	7403238.0
2007-03-15 11:30:00	SPY	ETF	139.79	139.81	139.33	139.43	6255446.0
2007-03-15 12:00:00	SPY	ETF	139.43	139.77	139.34	139.73	5946900.0
2007-03-15 12:30:00	SPY	ETF	139.74	139.9	139.48	139.72	5195319.0
2007-03-15 13:00:00	SPY	ETF	139.71	139.92	139.55	139.62	5075150.0
2007-03-15 13:30:00	SPY	ETF	139.62	139.71	139.08	139.5	14283825.0
2007-03-15 14:00:00	SPY	ETF	139.5	139.61	139.29	139.44	5102700.0
2007-03-15 14:30:00	SPY	ETF	139.44	139.83	139.43	139.67	5889994.0
2007-03-15 15:00:00	SPY	ETF	139.66	139.76	139.47	139.49	3877400.0
2007-03-15 15:30:00	SPY	ETF	139.49	139.71	139.49	139.57	10948540.0
2007-03-15 16:00:00	SPY	ETF	139.58	139.67	139.47	139.47	1333200.0
2007-03-15 16:30:00	SPY	ETF	139.5	139.51	139.34	139.37	448900.0
2007-03-15 17:00:00	SPY	ETF	139.37	139.37	139.2	139.25	151100.0
2007-03-15 17:30:00	SPY	ETF	139.25	139.29	139.21	139.25	11900.0
2007-03-15 18:00:00	SPY	ETF	139.25	139.28	139.21	139.27	7100.0
2007-03-15 18:30:00	SPY	ETF	139.3	139.32	139.3	139.32	4600.0
2007-03-15 19:00:00	SPY	ETF	139.3	139.32	139.3	139.32	1600.0
2007-03-15 19:30:00	SPY	ETF	139.3	139.3	139.2	139.23	15900.0
2007-03-15 07:00:00	QQQ	ETF	43.03	43.15	43.03	43.14	280200.0
2007-03-15 07:30:00	QQQ	ETF	43.13	43.15	43.13	43.13	55629.0
2007-03-15 08:00:00	QQQ	ETF	43.11	43.17	43.1	43.14	204032.0
2007-03-15 08:30:00	QQQ	ETF	43.11	43.11	42.88	42.94	3545429.0
2007-03-15 09:00:00	QQQ	ETF	42.94	42.98	42.82	42.86	946742.0
2007-03-15 09:30:00	QQQ	ETF	42.85	43.04	42.81	43.02	13456900.0
2007-03-15 10:00:00	QQQ	ETF	43.03	43.03	42.87	43.01	8455200.0
2007-03-15 10:30:00	QQQ	ETF	43.01	43.06	42.92	42.95	6472200.0
2007-03-15 11:00:00	QQQ	ETF	42.95	43.06	42.82	42.95	11188800.0
2007-03-15 11:30:00	QQQ	ETF	42.94	42.97	42.8	42.84	8186300.0
2007-03-15 12:00:00	QQQ	ETF	42.84	42.93	42.8	42.91	7718600.0
2007-03-15 12:30:00	QQQ	ETF	42.91	42.99	42.91	42.91	3732600.0
2007-03-15 13:00:00	QQQ	ETF	42.92	42.96	42.86	42.88	5725000.0
2007-03-15 13:30:00	QQQ	ETF	42.87	42.89	42.72	42.84	11391600.0
2007-03-15 14:00:00	QQQ	ETF	42.84	42.9	42.82	42.84	3546800.0
2007-03-15 14:30:00	QQQ	ETF	42.84	42.97	42.84	42.9	5015900.0
2007-03-15 15:00:00	QQQ	ETF	42.9	42.97	42.87	42.91	3272400.0
2007-03-15 15:30:00	QQQ	ETF	42.9	42.98	42.89	42.89	10714700.0
2007-03-15 16:00:00	QQQ	ETF	42.89	42.93	42.87	42.9	3118897.0
2007-03-15 16:30:00	QQQ	ETF	42.9	42.92	42.83	42.83	154602.0
2007-03-15 17:00:00	QQQ	ETF	42.85	42.85	42.81	42.82	169104.0
2007-03-15 17:30:00	QQQ	ETF	42.83	42.84	42.82	42.83	26866.0
2007-03-15 18:00:00	QQQ	ETF	42.83	42.83	42.83	42.83	13680.0

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

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