PREVIEW / etf_30min / 2007-01-11

all etf 30-min files

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

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-11 06:30:00	SPY	ETF	141.53	141.53	141.53	141.53	17500.0
2007-01-11 07:00:00	SPY	ETF	141.53	141.53	141.35	141.4	22600.0
2007-01-11 07:30:00	SPY	ETF	141.39	141.54	141.3	141.46	294800.0
2007-01-11 08:00:00	SPY	ETF	141.41	141.54	141.17	141.22	1252200.0
2007-01-11 08:30:00	SPY	ETF	141.21	141.42	141.2	141.37	638900.0
2007-01-11 09:00:00	SPY	ETF	141.38	141.57	141.38	141.56	593800.0
2007-01-11 09:30:00	SPY	ETF	141.56	142.11	141.5	142.02	7218600.0
2007-01-11 10:00:00	SPY	ETF	142.02	142.28	141.94	142.06	4925400.0
2007-01-11 10:30:00	SPY	ETF	142.05	142.35	142.03	142.34	4591900.0
2007-01-11 11:00:00	SPY	ETF	142.33	142.61	142.33	142.4	5230300.0
2007-01-11 11:30:00	SPY	ETF	142.39	142.51	142.35	142.48	2321400.0
2007-01-11 12:00:00	SPY	ETF	142.47	142.62	142.42	142.52	2769400.0
2007-01-11 12:30:00	SPY	ETF	142.51	142.55	142.44	142.52	1268100.0
2007-01-11 13:00:00	SPY	ETF	142.52	142.53	142.24	142.26	3626400.0
2007-01-11 13:30:00	SPY	ETF	142.26	142.42	142.25	142.25	1860700.0
2007-01-11 14:00:00	SPY	ETF	142.25	142.26	142.01	142.2	4877100.0
2007-01-11 14:30:00	SPY	ETF	142.21	142.47	142.2	142.4	3048400.0
2007-01-11 15:00:00	SPY	ETF	142.41	142.5	142.08	142.27	3659500.0
2007-01-11 15:30:00	SPY	ETF	142.27	142.35	142.16	142.27	3751700.0
2007-01-11 16:00:00	SPY	ETF	142.26	142.3	142.16	142.23	952000.0
2007-01-11 16:30:00	SPY	ETF	142.2	142.21	142.16	142.18	831700.0
2007-01-11 17:00:00	SPY	ETF	142.17	142.2	142.17	142.2	13800.0
2007-01-11 18:00:00	SPY	ETF	142.19	142.19	142.19	142.19	900.0
2007-01-11 18:30:00	SPY	ETF	142.2	142.23	142.2	142.23	700.0
2007-01-11 06:00:00	QQQ	ETF	44.65	44.65	44.65	44.65	10000.0
2007-01-11 06:30:00	QQQ	ETF	44.74	44.74	44.74	44.74	4300.0
2007-01-11 07:00:00	QQQ	ETF	44.74	44.76	44.68	44.69	17200.0
2007-01-11 07:30:00	QQQ	ETF	44.67	44.71	44.63	44.71	159974.0
2007-01-11 08:00:00	QQQ	ETF	44.69	44.71	44.6	44.62	1240597.0
2007-01-11 08:30:00	QQQ	ETF	44.63	44.69	44.62	44.68	1004996.0
2007-01-11 09:00:00	QQQ	ETF	44.68	44.75	44.68	44.71	1270639.0
2007-01-11 09:30:00	QQQ	ETF	44.71	44.89	44.65	44.83	18608600.0
2007-01-11 10:00:00	QQQ	ETF	44.82	44.93	44.79	44.84	10443200.0
2007-01-11 10:30:00	QQQ	ETF	44.84	45.0	44.8	44.99	16617900.0
2007-01-11 11:00:00	QQQ	ETF	44.99	45.24	44.97	45.16	27968000.0
2007-01-11 11:30:00	QQQ	ETF	45.16	45.19	45.1	45.14	10738300.0
2007-01-11 12:00:00	QQQ	ETF	45.14	45.18	45.07	45.12	8994700.0
2007-01-11 12:30:00	QQQ	ETF	45.12	45.2	45.1	45.2	3841100.0
2007-01-11 13:00:00	QQQ	ETF	45.19	45.2	45.03	45.07	10908100.0
2007-01-11 13:30:00	QQQ	ETF	45.08	45.14	45.04	45.05	6420800.0
2007-01-11 14:00:00	QQQ	ETF	45.05	45.07	44.95	45.04	7107700.0
2007-01-11 14:30:00	QQQ	ETF	45.05	45.19	45.04	45.15	6390700.0
2007-01-11 15:00:00	QQQ	ETF	45.16	45.21	44.91	45.04	14509000.0
2007-01-11 15:30:00	QQQ	ETF	45.04	45.11	44.98	45.07	14306500.0
2007-01-11 16:00:00	QQQ	ETF	45.07	45.12	45.05	45.08	3910190.0
2007-01-11 16:30:00	QQQ	ETF	45.07	45.09	45.07	45.08	736168.0
2007-01-11 17:00:00	QQQ	ETF	45.08	45.1	45.07	45.1	52424.0
2007-01-11 17:30:00	QQQ	ETF	45.1	45.12	45.09	45.09	27600.0
2007-01-11 18:00:00	QQQ	ETF	45.1	45.1	45.09	45.1	8118.0
2007-01-11 18:30:00	QQQ	ETF	45.1	45.12	45.1	45.11	9847.0

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

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