PREVIEW / etf_30min / 2007-01-19

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-19.parquet
  size:    94 KB
  rows:    3,285

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-19 04:00:00	SPY	ETF	142.5	142.5	142.5	142.5	1900.0
2007-01-19 07:00:00	SPY	ETF	142.44	142.49	142.44	142.44	16100.0
2007-01-19 07:30:00	SPY	ETF	142.43	142.5	142.35	142.46	49200.0
2007-01-19 08:00:00	SPY	ETF	142.45	142.5	142.35	142.48	364900.0
2007-01-19 08:30:00	SPY	ETF	142.46	142.48	142.37	142.48	580300.0
2007-01-19 09:00:00	SPY	ETF	142.48	142.67	142.46	142.52	884600.0
2007-01-19 09:30:00	SPY	ETF	142.54	142.84	142.46	142.54	7098200.0
2007-01-19 10:00:00	SPY	ETF	142.55	142.8	142.49	142.66	6440300.0
2007-01-19 10:30:00	SPY	ETF	142.67	143.1	142.59	142.97	7000000.0
2007-01-19 11:00:00	SPY	ETF	142.96	143.04	142.89	142.9201	3974600.0
2007-01-19 11:30:00	SPY	ETF	142.92	142.93	142.74	142.83	2912600.0
2007-01-19 12:00:00	SPY	ETF	142.83	142.91	142.57	142.66	3590700.0
2007-01-19 12:30:00	SPY	ETF	142.66	142.77	142.52	142.65	3078400.0
2007-01-19 13:00:00	SPY	ETF	142.66	142.87	142.65	142.82	1539600.0
2007-01-19 13:30:00	SPY	ETF	142.82	142.86	142.66	142.78	1711200.0
2007-01-19 14:00:00	SPY	ETF	142.79	142.99	142.77	142.87	3592100.0
2007-01-19 14:30:00	SPY	ETF	142.88	143.0	142.8	142.95	2494000.0
2007-01-19 15:00:00	SPY	ETF	142.95	142.98	142.83	142.875	2250500.0
2007-01-19 15:30:00	SPY	ETF	142.87	142.98	142.85	142.93	3646200.0
2007-01-19 16:00:00	SPY	ETF	142.94	142.96	142.82	142.83	3413800.0
2007-01-19 16:30:00	SPY	ETF	142.83	143.03	142.83	142.9	297100.0
2007-01-19 17:00:00	SPY	ETF	142.9	142.96	142.9	142.95	28900.0
2007-01-19 17:30:00	SPY	ETF	142.95	142.95	142.9	142.95	26000.0
2007-01-19 18:00:00	SPY	ETF	142.95	142.95	142.95	142.95	5800.0
2007-01-19 06:30:00	QQQ	ETF	44.02	44.02	44.02	44.02	20000.0
2007-01-19 07:00:00	QQQ	ETF	43.96	43.96	43.92	43.95	110000.0
2007-01-19 07:30:00	QQQ	ETF	43.95	43.96	43.91	43.96	118900.0
2007-01-19 08:00:00	QQQ	ETF	43.96	43.98	43.92	43.97	157500.0
2007-01-19 08:30:00	QQQ	ETF	43.95	44.05	43.95	44.05	783118.0
2007-01-19 09:00:00	QQQ	ETF	44.05	44.07	43.98	43.98	1586489.0
2007-01-19 09:30:00	QQQ	ETF	43.98	44.13	43.91	43.99	20156800.0
2007-01-19 10:00:00	QQQ	ETF	43.99	44.12	43.94	44.06	11880300.0
2007-01-19 10:30:00	QQQ	ETF	44.06	44.27	44.02	44.18	19507200.0
2007-01-19 11:00:00	QQQ	ETF	44.18	44.28	44.17	44.18	8681400.0
2007-01-19 11:30:00	QQQ	ETF	44.19	44.2	44.03	44.1	9633300.0
2007-01-19 12:00:00	QQQ	ETF	44.11	44.17	43.99	44.05	6438600.0
2007-01-19 12:30:00	QQQ	ETF	44.05	44.06	43.96	44.0	4784800.0
2007-01-19 13:00:00	QQQ	ETF	44.04	44.17	44.04	44.15	5481100.0
2007-01-19 13:30:00	QQQ	ETF	44.14	44.16	44.07	44.12	3692200.0
2007-01-19 14:00:00	QQQ	ETF	44.12	44.25	44.12	44.19	10211000.0
2007-01-19 14:30:00	QQQ	ETF	44.18	44.26	44.16	44.23	2465800.0
2007-01-19 15:00:00	QQQ	ETF	44.23	44.25	44.13	44.17	3447100.0
2007-01-19 15:30:00	QQQ	ETF	44.16	44.18	44.11	44.16	9585500.0
2007-01-19 16:00:00	QQQ	ETF	44.16	44.17	43.75	44.1	4914521.0
2007-01-19 16:30:00	QQQ	ETF	44.09	44.16	44.09	44.15	1848909.0
2007-01-19 17:00:00	QQQ	ETF	44.15	44.18	44.14	44.17	217300.0
2007-01-19 17:30:00	QQQ	ETF	44.16	44.17	44.13	44.15	49035.0
2007-01-19 18:00:00	QQQ	ETF	44.15	44.18	44.15	44.18	5200.0
2007-01-19 18:30:00	QQQ	ETF	44.17	44.19	44.17	44.19	14635.0
2007-01-19 19:00:00	QQQ	ETF	44.2	44.21	44.2	44.2	6185.0

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

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