PREVIEW / etf_30min / 2007-01-08

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-08.parquet
  size:    92 KB
  rows:    3,189

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-08 04:00:00	SPY	ETF	140.86	140.86	140.86	140.86	2000.0
2007-01-08 07:00:00	SPY	ETF	140.75	140.81	140.7	140.75	46400.0
2007-01-08 07:30:00	SPY	ETF	140.81	140.92	140.79	140.9	223800.0
2007-01-08 08:00:00	SPY	ETF	140.9	140.96	140.74	140.89	431400.0
2007-01-08 08:30:00	SPY	ETF	140.89	140.91	140.86	140.9	140300.0
2007-01-08 09:00:00	SPY	ETF	140.9	140.92	140.83	140.83	548600.0
2007-01-08 09:30:00	SPY	ETF	140.82	140.94	140.43	140.54	10658900.0
2007-01-08 10:00:00	SPY	ETF	140.54	140.8503	140.25	140.36	11742900.0
2007-01-08 10:30:00	SPY	ETF	140.37	140.82	140.34	140.44	5338200.0
2007-01-08 11:00:00	SPY	ETF	140.44	140.9	140.39	140.7	2884700.0
2007-01-08 11:30:00	SPY	ETF	140.68	140.86	140.59	140.8	6079400.0
2007-01-08 12:00:00	SPY	ETF	140.79	140.82	140.62	140.64	1639300.0
2007-01-08 12:30:00	SPY	ETF	140.64	140.75	140.54	140.68	1677300.0
2007-01-08 13:00:00	SPY	ETF	140.68	140.71	140.55	140.68	1409200.0
2007-01-08 13:30:00	SPY	ETF	140.67	141.1399	140.67	141.07	6104300.0
2007-01-08 14:00:00	SPY	ETF	141.06	141.31	140.99	141.24	4812500.0
2007-01-08 14:30:00	SPY	ETF	141.23	141.24	140.99	141.0	2715100.0
2007-01-08 15:00:00	SPY	ETF	141.0	141.41	140.97	141.22	3881000.0
2007-01-08 15:30:00	SPY	ETF	141.23	141.35	141.12	141.17	4800000.0
2007-01-08 16:00:00	SPY	ETF	141.15	141.24	140.2035	141.18	2677500.0
2007-01-08 16:30:00	SPY	ETF	141.21	141.24	141.18	141.24	16300.0
2007-01-08 17:00:00	SPY	ETF	141.25	141.27	141.22	141.25	3700.0
2007-01-08 18:00:00	SPY	ETF	141.21	141.21	141.2	141.2	600.0
2007-01-08 18:30:00	SPY	ETF	141.23	141.24	141.23	141.24	300.0
2007-01-08 19:00:00	SPY	ETF	141.23	141.26	141.23	141.26	5000.0
2007-01-08 19:30:00	SPY	ETF	141.27	141.32	141.27	141.31	15100.0
2007-01-08 07:00:00	QQQ	ETF	43.81	43.81	43.77	43.77	3000.0
2007-01-08 07:30:00	QQQ	ETF	43.82	43.84	43.77	43.84	190900.0
2007-01-08 08:00:00	QQQ	ETF	43.83	43.88	43.8	43.85	951167.0
2007-01-08 08:30:00	QQQ	ETF	43.84	43.91	43.84	43.9	1284447.0
2007-01-08 09:00:00	QQQ	ETF	43.9	43.92	43.88	43.89	2247934.0
2007-01-08 09:30:00	QQQ	ETF	43.88	44.03	43.72	43.88	20129900.0
2007-01-08 10:00:00	QQQ	ETF	43.87	43.96	43.64	43.74	14705000.0
2007-01-08 10:30:00	QQQ	ETF	43.73	43.99	43.71	43.84	7952200.0
2007-01-08 11:00:00	QQQ	ETF	43.84	44.06	43.83	43.94	6532700.0
2007-01-08 11:30:00	QQQ	ETF	43.94	43.99	43.89	43.98	3749800.0
2007-01-08 12:00:00	QQQ	ETF	43.98	44.0	43.88	43.89	2669800.0
2007-01-08 12:30:00	QQQ	ETF	43.89	43.92	43.8	43.91	3604900.0
2007-01-08 13:00:00	QQQ	ETF	43.91	44.02	43.82	43.89	2005200.0
2007-01-08 13:30:00	QQQ	ETF	43.9	44.08	43.9	44.02	5663200.0
2007-01-08 14:00:00	QQQ	ETF	44.02	44.12	43.97	44.05	6202800.0
2007-01-08 14:30:00	QQQ	ETF	44.05	44.06	43.92	43.92	3408900.0
2007-01-08 15:00:00	QQQ	ETF	43.92	44.07	43.91	43.98	5538800.0
2007-01-08 15:30:00	QQQ	ETF	43.98	44.02	43.89	43.9	6038700.0
2007-01-08 16:00:00	QQQ	ETF	43.88	43.92	43.85	43.91	962204.0
2007-01-08 16:30:00	QQQ	ETF	43.91	43.94	43.9	43.94	3532592.0
2007-01-08 17:00:00	QQQ	ETF	43.94	43.94	43.92	43.92	6545.0
2007-01-08 17:30:00	QQQ	ETF	43.93	43.93	43.93	43.93	6040.0
2007-01-08 18:00:00	QQQ	ETF	43.92	43.92	43.91	43.91	22025.0
2007-01-08 18:30:00	QQQ	ETF	43.91	43.91	43.91	43.91	1000.0

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

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