PREVIEW / etf_30min / 2005-03-07

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-03-07.parquet
  size:    44 KB
  rows:    1,545

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
2005-03-07 08:00:00	SPY	ETF	122.73	122.76	122.68	122.76	33300.0
2005-03-07 08:30:00	SPY	ETF	122.76	122.79	122.64	122.66	58400.0
2005-03-07 09:00:00	SPY	ETF	122.69	122.77	122.65	122.65	69300.0
2005-03-07 09:30:00	SPY	ETF	122.66	122.96	122.59	122.87	7017000.0
2005-03-07 10:00:00	SPY	ETF	122.87	123.09	122.4	122.87	4764800.0
2005-03-07 10:30:00	SPY	ETF	122.86	122.98	122.71	122.82	5451900.0
2005-03-07 11:00:00	SPY	ETF	122.82	123.14	122.79	123.12	2056800.0
2005-03-07 11:30:00	SPY	ETF	123.12	123.25	123.0	123.06	3372800.0
2005-03-07 12:00:00	SPY	ETF	123.06	123.24	122.88	123.16	1691100.0
2005-03-07 12:30:00	SPY	ETF	123.16	123.2	123.02	123.05	1347500.0
2005-03-07 13:00:00	SPY	ETF	123.06	123.18	122.94	122.97	2729000.0
2005-03-07 13:30:00	SPY	ETF	122.99	123.1	122.93	123.03	1908200.0
2005-03-07 14:00:00	SPY	ETF	123.03	123.1	122.75	122.79	1858600.0
2005-03-07 14:30:00	SPY	ETF	122.8	123.04	122.79	123.0	1644100.0
2005-03-07 15:00:00	SPY	ETF	123.0	123.13	122.94	123.01	1938100.0
2005-03-07 15:30:00	SPY	ETF	123.01	123.03	122.74	122.78	4000400.0
2005-03-07 16:00:00	SPY	ETF	122.84	122.85	122.76	122.84	757700.0
2005-03-07 16:30:00	SPY	ETF	122.8	122.83	122.63	122.7	240400.0
2005-03-07 17:00:00	SPY	ETF	122.71	122.72	122.66	122.67	116700.0
2005-03-07 17:30:00	SPY	ETF	122.72	122.72	122.7	122.7	600.0
2005-03-07 18:00:00	SPY	ETF	122.69	122.69	122.68	122.68	500.0
2005-03-07 18:30:00	SPY	ETF	122.65	122.65	122.65	122.65	500.0
2005-03-07 19:30:00	SPY	ETF	122.65	122.65	122.65	122.65	400.0
2005-03-07 09:30:00	QQQ	ETF	37.6	37.97	37.56	37.93	14280900.0
2005-03-07 10:00:00	QQQ	ETF	37.94	38.14	37.08	38.05	14908500.0
2005-03-07 10:30:00	QQQ	ETF	38.05	38.2	38.02	38.09	9692200.0
2005-03-07 11:00:00	QQQ	ETF	38.08	38.2	37.11	38.18	5269700.0
2005-03-07 11:30:00	QQQ	ETF	38.17	38.24	38.13	38.13	5934800.0
2005-03-07 12:00:00	QQQ	ETF	38.13	38.29	38.12	38.24	5547400.0
2005-03-07 12:30:00	QQQ	ETF	38.24	38.25	38.18	38.19	2964200.0
2005-03-07 13:00:00	QQQ	ETF	38.19	38.24	38.1	38.12	2951300.0
2005-03-07 13:30:00	QQQ	ETF	38.13	38.18	38.1	38.17	2672900.0
2005-03-07 14:00:00	QQQ	ETF	38.17	38.21	38.05	38.05	5012800.0
2005-03-07 14:30:00	QQQ	ETF	38.05	38.15	38.05	38.12	3311300.0
2005-03-07 15:00:00	QQQ	ETF	38.12	38.22	38.09	38.14	2742200.0
2005-03-07 15:30:00	QQQ	ETF	38.13	38.15	38.0	38.04	9240200.0
2005-03-07 08:00:00	IWM	ETF	64.425	64.425	64.425	64.425	1800.0
2005-03-07 08:30:00	IWM	ETF	64.39	64.39	64.39	64.39	1800.0
2005-03-07 09:00:00	IWM	ETF	64.35	64.35	64.35	64.35	600.0
2005-03-07 09:30:00	IWM	ETF	64.45	64.475	64.265	64.38	1730200.0
2005-03-07 10:00:00	IWM	ETF	64.39	64.59	64.39	64.455	1214200.0
2005-03-07 10:30:00	IWM	ETF	64.475	64.53	64.325	64.375	821600.0
2005-03-07 11:00:00	IWM	ETF	64.37	64.57	64.355	64.555	526200.0
2005-03-07 11:30:00	IWM	ETF	64.54	64.635	64.495	64.535	1056400.0
2005-03-07 12:00:00	IWM	ETF	64.525	64.64	64.51	64.565	342200.0
2005-03-07 12:30:00	IWM	ETF	64.56	64.56	64.385	64.41	794600.0
2005-03-07 13:00:00	IWM	ETF	64.415	64.485	64.34	64.35	757200.0
2005-03-07 13:30:00	IWM	ETF	64.36	64.56	64.35	64.55	823000.0
2005-03-07 14:00:00	IWM	ETF	64.55	64.61	64.17	64.18	961200.0
2005-03-07 14:30:00	IWM	ETF	64.18	64.345	64.175	64.265	1229200.0

> showing 50 of 1,545 rows — these rows as CSV

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