PREVIEW / etf_30min / 2007-01-12

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-12.parquet
  size:    95 KB
  rows:    3,340

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-01-12 04:00:00	SPY	ETF	142.34	142.34	142.34	142.34	300.0
2007-01-12 04:30:00	SPY	ETF	142.3	142.3	142.3	142.3	2800.0
2007-01-12 06:00:00	SPY	ETF	142.15	142.15	142.15	142.15	15000.0
2007-01-12 06:30:00	SPY	ETF	142.22	142.23	142.22	142.23	5000.0
2007-01-12 07:00:00	SPY	ETF	142.16	142.16	142.15	142.16	251300.0
2007-01-12 07:30:00	SPY	ETF	142.08	142.1	142.03	142.09	111800.0
2007-01-12 08:00:00	SPY	ETF	142.05	142.19	142.02	142.19	545200.0
2007-01-12 08:30:00	SPY	ETF	142.16	142.36	141.94	142.1	2178500.0
2007-01-12 09:00:00	SPY	ETF	142.09	142.14	142.05	142.11	149500.0
2007-01-12 09:30:00	SPY	ETF	142.12	142.67	142.11	142.61	8081200.0
2007-01-12 10:00:00	SPY	ETF	142.61	142.63	142.34	142.35	5648400.0
2007-01-12 10:30:00	SPY	ETF	142.35	142.43	142.16	142.41	5486700.0
2007-01-12 11:00:00	SPY	ETF	142.41	142.51	142.25	142.45	2370500.0
2007-01-12 11:30:00	SPY	ETF	142.45	142.8	142.35	142.71	5239700.0
2007-01-12 12:00:00	SPY	ETF	142.72	142.83	142.61	142.78	2507700.0
2007-01-12 12:30:00	SPY	ETF	142.78	143.03	142.72	142.97	3141700.0
2007-01-12 13:00:00	SPY	ETF	142.99	142.99	142.85	142.85	1322400.0
2007-01-12 13:30:00	SPY	ETF	142.85	142.98	142.81	142.92	2206900.0
2007-01-12 14:00:00	SPY	ETF	142.92	142.93	142.74	142.83	2134200.0
2007-01-12 14:30:00	SPY	ETF	142.83	142.88	142.77	142.82	1235000.0
2007-01-12 15:00:00	SPY	ETF	142.82	143.03	142.81	142.96	4758200.0
2007-01-12 15:30:00	SPY	ETF	142.96	143.01	142.88	142.97	4797200.0
2007-01-12 16:00:00	SPY	ETF	142.97	143.3	142.96	143.25	1297500.0
2007-01-12 16:30:00	SPY	ETF	143.28	143.35	142.907	143.29	1149300.0
2007-01-12 17:00:00	SPY	ETF	143.27	143.32	143.0	143.18	63900.0
2007-01-12 17:30:00	SPY	ETF	143.18	143.25	143.17	143.18	33000.0
2007-01-12 18:00:00	SPY	ETF	143.2	143.27	143.2	143.27	700.0
2007-01-12 18:30:00	SPY	ETF	143.27	143.27	143.21	143.21	5100.0
2007-01-12 19:00:00	SPY	ETF	143.2	143.27	143.18	143.27	1800.0
2007-01-12 19:30:00	SPY	ETF	143.27	143.27	143.27	143.27	3900.0
2007-01-12 05:00:00	QQQ	ETF	45.12	45.12	45.12	45.12	1000.0
2007-01-12 06:00:00	QQQ	ETF	45.09	45.09	45.07	45.07	125000.0
2007-01-12 07:00:00	QQQ	ETF	45.11	45.11	44.99	44.99	803472.0
2007-01-12 07:30:00	QQQ	ETF	44.99	45.04	44.9	45.03	266135.0
2007-01-12 08:00:00	QQQ	ETF	45.0	45.09	45.0	45.06	1270605.0
2007-01-12 08:30:00	QQQ	ETF	45.12	45.15	45.01	45.05	895216.0
2007-01-12 09:00:00	QQQ	ETF	45.05	45.05	44.98	45.01	947380.0
2007-01-12 09:30:00	QQQ	ETF	45.02	45.32	45.01	45.28	21437100.0
2007-01-12 10:00:00	QQQ	ETF	45.29	45.29	45.06	45.07	15107000.0
2007-01-12 10:30:00	QQQ	ETF	45.07	45.14	44.97	45.13	11238800.0
2007-01-12 11:00:00	QQQ	ETF	45.12	45.18	45.07	45.14	5891600.0
2007-01-12 11:30:00	QQQ	ETF	45.13	45.29	45.1	45.23	9813800.0
2007-01-12 12:00:00	QQQ	ETF	45.23	45.3	45.18	45.29	2728400.0
2007-01-12 12:30:00	QQQ	ETF	45.3	45.35	45.2	45.32	4835800.0
2007-01-12 13:00:00	QQQ	ETF	45.32	45.33	45.25	45.25	3163300.0
2007-01-12 13:30:00	QQQ	ETF	45.25	45.3	45.22	45.27	3362100.0
2007-01-12 14:00:00	QQQ	ETF	45.26	45.28	45.18	45.24	3977300.0
2007-01-12 14:30:00	QQQ	ETF	45.25	45.26	45.19	45.22	2786900.0
2007-01-12 15:00:00	QQQ	ETF	45.21	45.33	45.21	45.29	5170200.0
2007-01-12 15:30:00	QQQ	ETF	45.29	45.33	45.28	45.32	6170700.0

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

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