PREVIEW / etf_30min / 2007-03-19

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-19.parquet
  size:    102 KB
  rows:    3,563

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-19 04:00:00	SPY	ETF	138.8	138.99	138.8	138.99	1200.0
2007-03-19 06:00:00	SPY	ETF	139.38	139.38	139.38	139.38	5900.0
2007-03-19 06:30:00	SPY	ETF	139.23	139.23	139.22	139.22	25000.0
2007-03-19 07:00:00	SPY	ETF	139.22	139.34	139.22	139.28	151400.0
2007-03-19 07:30:00	SPY	ETF	139.31	139.33	139.22	139.24	437700.0
2007-03-19 08:00:00	SPY	ETF	139.25	139.31	139.2	139.29	813000.0
2007-03-19 08:30:00	SPY	ETF	139.3	139.36	139.21	139.28	524800.0
2007-03-19 09:00:00	SPY	ETF	139.29	139.39	138.55	139.27	466200.0
2007-03-19 09:30:00	SPY	ETF	139.26	139.66	139.26	139.41	14018093.0
2007-03-19 10:00:00	SPY	ETF	139.41	139.48	139.15	139.43	6588350.0
2007-03-19 10:30:00	SPY	ETF	139.43	139.9	139.35	139.82	10422595.0
2007-03-19 11:00:00	SPY	ETF	139.82	139.98	139.75	139.92	6438750.0
2007-03-19 11:30:00	SPY	ETF	139.92	140.18	139.83	140.08	8155650.0
2007-03-19 12:00:00	SPY	ETF	140.09	140.2	140.0	140.02	3272166.0
2007-03-19 12:30:00	SPY	ETF	140.02	140.02	139.79	139.88	3790300.0
2007-03-19 13:00:00	SPY	ETF	139.88	139.97	139.75	139.86	4169550.0
2007-03-19 13:30:00	SPY	ETF	139.86	140.1	139.83	140.03	2708000.0
2007-03-19 14:00:00	SPY	ETF	140.04	140.1	139.85	139.88	6246300.0
2007-03-19 14:30:00	SPY	ETF	139.87	140.15	139.83	140.03	3250300.0
2007-03-19 15:00:00	SPY	ETF	140.04	140.05	139.77	139.8	4831300.0
2007-03-19 15:30:00	SPY	ETF	139.8	140.33	139.75	140.07	6766600.0
2007-03-19 16:00:00	SPY	ETF	140.07	140.23	139.98	140.19	9012700.0
2007-03-19 16:30:00	SPY	ETF	140.19	140.23	140.14	140.2	91600.0
2007-03-19 17:00:00	SPY	ETF	140.2	140.23	140.17	140.22	168600.0
2007-03-19 17:30:00	SPY	ETF	140.22	140.31	140.22	140.31	35500.0
2007-03-19 18:00:00	SPY	ETF	140.32	140.32	140.24	140.24	130300.0
2007-03-19 18:30:00	SPY	ETF	140.22	140.25	140.21	140.25	1500.0
2007-03-19 19:00:00	SPY	ETF	140.22	140.26	140.22	140.24	2700.0
2007-03-19 19:30:00	SPY	ETF	140.24	140.25	140.22	140.23	2400.0
2007-03-19 04:00:00	QQQ	ETF	43.03	43.03	43.03	43.03	200.0
2007-03-19 07:00:00	QQQ	ETF	43.06	43.1	43.04	43.07	46000.0
2007-03-19 07:30:00	QQQ	ETF	43.07	43.08	43.05	43.08	168244.0
2007-03-19 08:00:00	QQQ	ETF	43.07	43.11	43.07	43.1	344285.0
2007-03-19 08:30:00	QQQ	ETF	43.1	43.11	43.05	43.09	411827.0
2007-03-19 09:00:00	QQQ	ETF	43.08	43.09	43.05	43.07	816495.0
2007-03-19 09:30:00	QQQ	ETF	43.06	43.15	43.02	43.08	13021100.0
2007-03-19 10:00:00	QQQ	ETF	43.07	43.1	42.95	43.04	5786700.0
2007-03-19 10:30:00	QQQ	ETF	43.04	43.25	43.02	43.23	9780200.0
2007-03-19 11:00:00	QQQ	ETF	43.23	43.35	43.21	43.25	8051800.0
2007-03-19 11:30:00	QQQ	ETF	43.24	43.39	43.22	43.35	6283100.0
2007-03-19 12:00:00	QQQ	ETF	43.34	43.35	43.26	43.26	2504000.0
2007-03-19 12:30:00	QQQ	ETF	43.26	43.27	43.16	43.2	6402600.0
2007-03-19 13:00:00	QQQ	ETF	43.19	43.22	43.12	43.18	4672200.0
2007-03-19 13:30:00	QQQ	ETF	43.18	43.28	43.16	43.25	2911100.0
2007-03-19 14:00:00	QQQ	ETF	43.24	43.28	43.18	43.18	3831800.0
2007-03-19 14:30:00	QQQ	ETF	43.18	43.25	43.17	43.2	6381400.0
2007-03-19 15:00:00	QQQ	ETF	43.2	43.22	43.07	43.1	6991000.0
2007-03-19 15:30:00	QQQ	ETF	43.1	43.21	43.07	43.21	7766900.0
2007-03-19 16:00:00	QQQ	ETF	43.21	43.37	43.195	43.31	7712308.0
2007-03-19 16:30:00	QQQ	ETF	43.32	43.32	43.29	43.31	84456.0

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

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