PREVIEW / etf_30min / 2007-06-27

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-27.parquet
  size:    123 KB
  rows:    4,494

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-06-27 04:00:00	SPY	ETF	148.5	148.5	148.46	148.46	1400.0
2007-06-27 05:00:00	SPY	ETF	148.4	148.4	148.4	148.4	2000.0
2007-06-27 06:00:00	SPY	ETF	148.54	148.54	148.54	148.54	5000.0
2007-06-27 06:30:00	SPY	ETF	148.59	148.7	148.51	148.7	18500.0
2007-06-27 07:00:00	SPY	ETF	148.66	148.7	148.4	148.4	357100.0
2007-06-27 07:30:00	SPY	ETF	148.32	148.43	148.27	148.27	805700.0
2007-06-27 08:00:00	SPY	ETF	148.28	148.3	148.11	148.26	1776100.0
2007-06-27 08:30:00	SPY	ETF	148.26	148.29	147.81	148.06	16684100.0
2007-06-27 09:00:00	SPY	ETF	148.09	148.26	147.89	148.24	2989386.0
2007-06-27 09:30:00	SPY	ETF	148.24	148.84	148.06	148.59	30704799.0
2007-06-27 10:00:00	SPY	ETF	148.6	148.8	148.38	148.76	18064861.0
2007-06-27 10:30:00	SPY	ETF	148.77	149.19	148.72	148.81	17611435.0
2007-06-27 11:00:00	SPY	ETF	148.81	149.35	148.64	149.18	14234816.0
2007-06-27 11:30:00	SPY	ETF	149.18	149.18	148.88	148.99	6166930.0
2007-06-27 12:00:00	SPY	ETF	148.98	149.39	148.98	149.2426	8049434.0
2007-06-27 12:30:00	SPY	ETF	149.245	149.52	149.18	149.36	6505125.0
2007-06-27 13:00:00	SPY	ETF	149.37	149.475	148.97	149.11	8656950.0
2007-06-27 13:30:00	SPY	ETF	149.11	149.42	148.86	149.34	10137850.0
2007-06-27 14:00:00	SPY	ETF	149.34	149.94	149.34	149.85	14389393.0
2007-06-27 14:30:00	SPY	ETF	149.84	150.07	149.67	149.9	10197904.0
2007-06-27 15:00:00	SPY	ETF	149.89	150.2	149.85	150.14	10846126.0
2007-06-27 15:30:00	SPY	ETF	150.12	150.56	150.11	150.55	21281557.0
2007-06-27 16:00:00	SPY	ETF	150.56	150.57	148.7793	150.39	5256500.0
2007-06-27 16:30:00	SPY	ETF	150.39	150.48	150.39	150.45	612800.0
2007-06-27 17:00:00	SPY	ETF	150.44	150.46	150.37	150.39	448000.0
2007-06-27 17:30:00	SPY	ETF	150.43	150.43	150.21	150.34	11600.0
2007-06-27 18:00:00	SPY	ETF	150.35	150.47	150.35	150.47	132700.0
2007-06-27 18:30:00	SPY	ETF	150.42	150.47	150.42	150.47	4467500.0
2007-06-27 19:00:00	SPY	ETF	150.45	150.46	150.45	150.46	400.0
2007-06-27 19:30:00	SPY	ETF	150.46	150.47	150.46	150.47	800.0
2007-06-27 06:30:00	QQQ	ETF	46.86	46.88	46.86	46.88	15000.0
2007-06-27 07:00:00	QQQ	ETF	46.87	46.87	46.78	46.8	273400.0
2007-06-27 07:30:00	QQQ	ETF	46.8	46.83	46.78	46.8	321492.0
2007-06-27 08:00:00	QQQ	ETF	46.8	46.82	46.71	46.78	1234068.0
2007-06-27 08:30:00	QQQ	ETF	46.78	46.95	46.62	46.72	2645920.0
2007-06-27 09:00:00	QQQ	ETF	46.72	46.78	46.66	46.77	491470.0
2007-06-27 09:30:00	QQQ	ETF	46.76	47.03	46.7	46.97	18591717.0
2007-06-27 10:00:00	QQQ	ETF	46.96	47.01	46.88	47.01	10908118.0
2007-06-27 10:30:00	QQQ	ETF	47.0	47.11	46.97	46.9709	14153348.0
2007-06-27 11:00:00	QQQ	ETF	46.97	47.15	46.92	47.11	9327290.0
2007-06-27 11:30:00	QQQ	ETF	47.11	47.11	47.0	47.03	5197570.0
2007-06-27 12:00:00	QQQ	ETF	47.03	47.17	47.025	47.12	5951484.0
2007-06-27 12:30:00	QQQ	ETF	47.12	47.21	47.09	47.17	4671604.0
2007-06-27 13:00:00	QQQ	ETF	47.17	47.21	47.08	47.11	5118533.0
2007-06-27 13:30:00	QQQ	ETF	47.1	47.18	47.04	47.16	5769722.0
2007-06-27 14:00:00	QQQ	ETF	47.16	47.36	47.16	47.34	11951434.0
2007-06-27 14:30:00	QQQ	ETF	47.34	47.45	47.32	47.3792	8094738.0
2007-06-27 15:00:00	QQQ	ETF	47.38	47.48	47.36	47.45	7068963.0
2007-06-27 15:30:00	QQQ	ETF	47.44	47.56	47.43	47.55	18087078.0
2007-06-27 16:00:00	QQQ	ETF	47.54	47.56	47.47	47.48	3808010.0

> showing 50 of 4,494 rows — these rows as CSV

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