PREVIEW / etf_30min / 2007-03-08

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-08.parquet
  size:    104 KB
  rows:    3,662

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-08 04:00:00	SPY	ETF	140.41	140.41	140.41	140.41	400.0
2007-03-08 04:30:00	SPY	ETF	140.5	140.54	140.5	140.54	5800.0
2007-03-08 06:00:00	SPY	ETF	140.66	140.66	140.66	140.66	9000.0
2007-03-08 06:30:00	SPY	ETF	140.55	140.59	140.49	140.5	124300.0
2007-03-08 07:00:00	SPY	ETF	140.51	140.67	140.5	140.58	653100.0
2007-03-08 07:30:00	SPY	ETF	140.6	140.73	140.58	140.65	716500.0
2007-03-08 08:00:00	SPY	ETF	140.62	140.74	140.58	140.6	2436300.0
2007-03-08 08:30:00	SPY	ETF	140.59	140.71	140.47	140.6	1257700.0
2007-03-08 09:00:00	SPY	ETF	140.58	140.6	139.78	140.53	407600.0
2007-03-08 09:30:00	SPY	ETF	140.54	140.84	140.48	140.59	12257400.0
2007-03-08 10:00:00	SPY	ETF	140.6	141.09	140.58	141.06	13082800.0
2007-03-08 10:30:00	SPY	ETF	141.06	141.12	140.775	140.88	8633000.0
2007-03-08 11:00:00	SPY	ETF	140.88	140.94	140.71	140.82	5724700.0
2007-03-08 11:30:00	SPY	ETF	140.82	141.15	140.79	140.94	5928500.0
2007-03-08 12:00:00	SPY	ETF	140.94	141.03	140.88	140.94	2511500.0
2007-03-08 12:30:00	SPY	ETF	140.94	141.04	140.77	140.94	3168300.0
2007-03-08 13:00:00	SPY	ETF	140.94	141.09	140.85	141.04	1816600.0
2007-03-08 13:30:00	SPY	ETF	141.05	141.16	140.96	141.02	3882900.0
2007-03-08 14:00:00	SPY	ETF	141.02	141.06	140.62	140.62	7873800.0
2007-03-08 14:30:00	SPY	ETF	140.62	140.67	140.07	140.58	15818800.0
2007-03-08 15:00:00	SPY	ETF	140.58	140.7	140.49	140.6	5333200.0
2007-03-08 15:30:00	SPY	ETF	140.6	140.76	140.25	140.54	12028400.0
2007-03-08 16:00:00	SPY	ETF	140.55	140.8	140.47	140.75	6197600.0
2007-03-08 16:30:00	SPY	ETF	140.75	140.8	140.67	140.72	5258800.0
2007-03-08 17:00:00	SPY	ETF	140.72	140.78	140.69	140.69	145900.0
2007-03-08 17:30:00	SPY	ETF	140.73	140.78	140.66	140.74	35500.0
2007-03-08 18:00:00	SPY	ETF	140.73	140.75	140.69	140.7	2500.0
2007-03-08 18:30:00	SPY	ETF	140.7	140.75	140.7	140.75	5900.0
2007-03-08 19:30:00	SPY	ETF	140.75	140.76	140.73	140.76	5200.0
2007-03-08 04:00:00	QQQ	ETF	42.97	42.99	42.97	42.99	1700.0
2007-03-08 04:30:00	QQQ	ETF	43.03	43.03	43.03	43.03	200.0
2007-03-08 06:30:00	QQQ	ETF	43.12	43.12	43.11	43.11	700.0
2007-03-08 07:00:00	QQQ	ETF	43.1	43.22	43.09	43.18	612100.0
2007-03-08 07:30:00	QQQ	ETF	43.18	43.24	43.18	43.2	804210.0
2007-03-08 08:00:00	QQQ	ETF	43.2	43.23	43.18	43.18	1907961.0
2007-03-08 08:30:00	QQQ	ETF	43.18	43.22	43.1	43.18	2684114.0
2007-03-08 09:00:00	QQQ	ETF	43.18	43.18	43.11	43.13	1011590.0
2007-03-08 09:30:00	QQQ	ETF	43.12	43.22	43.03	43.05	17485200.0
2007-03-08 10:00:00	QQQ	ETF	43.05	43.2	43.01	43.18	13312000.0
2007-03-08 10:30:00	QQQ	ETF	43.18	43.24	43.13	43.16	11039900.0
2007-03-08 11:00:00	QQQ	ETF	43.17	43.19	43.11	43.16	5628200.0
2007-03-08 11:30:00	QQQ	ETF	43.16	43.23	43.15	43.17	6761300.0
2007-03-08 12:00:00	QQQ	ETF	43.18	43.22	43.14	43.14	2866500.0
2007-03-08 12:30:00	QQQ	ETF	43.15	43.2	43.1	43.15	2812200.0
2007-03-08 13:00:00	QQQ	ETF	43.16	43.2	43.12	43.18	1963900.0
2007-03-08 13:30:00	QQQ	ETF	43.18	43.23	43.16	43.17	3447900.0
2007-03-08 14:00:00	QQQ	ETF	43.17	43.17	43.02	43.02	8388400.0
2007-03-08 14:30:00	QQQ	ETF	43.02	43.03	42.84	42.99	13759300.0
2007-03-08 15:00:00	QQQ	ETF	42.99	43.03	42.95	42.99	4045200.0
2007-03-08 15:30:00	QQQ	ETF	42.99	43.15	42.88	42.96	9847300.0

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

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