PREVIEW / etf_30min / 2007-01-22

all etf 30-min files

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

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-22 07:00:00	SPY	ETF	143.1	143.13	143.1	143.13	15000.0
2007-01-22 08:00:00	SPY	ETF	143.12	143.15	143.04	143.08	116900.0
2007-01-22 08:30:00	SPY	ETF	143.06	143.11	143.04	143.07	275800.0
2007-01-22 09:00:00	SPY	ETF	143.1	143.1	143.04	143.06	93200.0
2007-01-22 09:30:00	SPY	ETF	143.07	143.1	142.76	142.83	4678400.0
2007-01-22 10:00:00	SPY	ETF	142.84	142.85	142.23	142.37	5937000.0
2007-01-22 10:30:00	SPY	ETF	142.37	142.42	142.1	142.26	7228600.0
2007-01-22 11:00:00	SPY	ETF	142.25	142.26	142.02	142.19	5686600.0
2007-01-22 11:30:00	SPY	ETF	142.1899	142.28	142.07	142.12	3806200.0
2007-01-22 12:00:00	SPY	ETF	142.11	142.2	141.97	142.09	3572100.0
2007-01-22 12:30:00	SPY	ETF	142.08	142.14	141.96	141.99	2325900.0
2007-01-22 13:00:00	SPY	ETF	141.99	142.2	141.93	142.18	2557900.0
2007-01-22 13:30:00	SPY	ETF	142.18	142.24	141.97	142.2	5672400.0
2007-01-22 14:00:00	SPY	ETF	142.19	142.35	142.19	142.33	3493800.0
2007-01-22 14:30:00	SPY	ETF	142.33	142.41	142.22	142.29	2862600.0
2007-01-22 15:00:00	SPY	ETF	142.29	142.37	142.05	142.17	3389900.0
2007-01-22 15:30:00	SPY	ETF	142.18	142.37	142.15	142.21	4741200.0
2007-01-22 16:00:00	SPY	ETF	142.21	142.41	142.18	142.35	661500.0
2007-01-22 16:30:00	SPY	ETF	142.36	142.44	142.33	142.43	925200.0
2007-01-22 17:00:00	SPY	ETF	142.39	142.4	142.39	142.39	2000.0
2007-01-22 17:30:00	SPY	ETF	142.4	142.45	142.38	142.38	1292100.0
2007-01-22 18:00:00	SPY	ETF	142.39	142.42	142.39	142.4	4600.0
2007-01-22 19:00:00	SPY	ETF	142.39	142.39	142.39	142.39	100.0
2007-01-22 19:30:00	SPY	ETF	142.38	142.39	142.38	142.39	1500.0
2007-01-22 07:00:00	QQQ	ETF	44.24	44.24	44.22	44.22	12050.0
2007-01-22 07:30:00	QQQ	ETF	44.23	44.25	44.23	44.25	19500.0
2007-01-22 08:00:00	QQQ	ETF	44.25	44.26	44.2	44.2	109736.0
2007-01-22 08:30:00	QQQ	ETF	44.21	44.22	44.2	44.2	161921.0
2007-01-22 09:00:00	QQQ	ETF	44.2	44.22	44.19	44.21	331989.0
2007-01-22 09:30:00	QQQ	ETF	44.22	44.23	43.97	44.03	20044300.0
2007-01-22 10:00:00	QQQ	ETF	44.03	44.04	43.62	43.74	25210200.0
2007-01-22 10:30:00	QQQ	ETF	43.74	43.75	43.58	43.59	10564200.0
2007-01-22 11:00:00	QQQ	ETF	43.6	43.63	43.51	43.57	8883400.0
2007-01-22 11:30:00	QQQ	ETF	43.56	43.68	43.52	43.61	6496000.0
2007-01-22 12:00:00	QQQ	ETF	43.61	43.65	43.53	43.63	4113900.0
2007-01-22 12:30:00	QQQ	ETF	43.64	43.69	43.56	43.59	8491000.0
2007-01-22 13:00:00	QQQ	ETF	43.59	43.71	43.56	43.69	5995200.0
2007-01-22 13:30:00	QQQ	ETF	43.69	43.71	43.58	43.69	4180400.0
2007-01-22 14:00:00	QQQ	ETF	43.7	43.76	43.66	43.74	5394900.0
2007-01-22 14:30:00	QQQ	ETF	43.74	43.8	43.68	43.75	4997000.0
2007-01-22 15:00:00	QQQ	ETF	43.74	43.76	43.66	43.71	4058100.0
2007-01-22 15:30:00	QQQ	ETF	43.71	43.78	43.68	43.69	7579300.0
2007-01-22 16:00:00	QQQ	ETF	43.7	43.73	43.65	43.73	1214557.0
2007-01-22 16:30:00	QQQ	ETF	43.7	43.78	43.69	43.75	740075.0
2007-01-22 17:00:00	QQQ	ETF	43.74	43.74	43.71	43.72	127169.0
2007-01-22 17:30:00	QQQ	ETF	43.73	43.76	43.73	43.76	16103.0
2007-01-22 18:00:00	QQQ	ETF	43.75	43.77	43.75	43.75	53200.0
2007-01-22 18:30:00	QQQ	ETF	43.76	43.76	43.74	43.74	25415.0
2007-01-22 19:00:00	QQQ	ETF	43.75	43.76	43.74	43.76	3285.0
2007-01-22 19:30:00	QQQ	ETF	43.76	43.76	43.76	43.76	2600.0

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

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