PREVIEW / etf_30min / 2007-07-11

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-11.parquet
  size:    117 KB
  rows:    4,567

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-07-11 04:00:00	SPY	ETF	151.22	151.22	151.19	151.19	6200.0
2007-07-11 04:30:00	SPY	ETF	151.22	151.22	151.22	151.22	1000.0
2007-07-11 05:00:00	SPY	ETF	151.36	151.37	151.36	151.36	8000.0
2007-07-11 05:30:00	SPY	ETF	151.36	151.36	151.32	151.35	25000.0
2007-07-11 06:00:00	SPY	ETF	151.43	151.43	151.29	151.29	30500.0
2007-07-11 06:30:00	SPY	ETF	151.28	151.28	151.24	151.24	36000.0
2007-07-11 07:00:00	SPY	ETF	151.15	151.15	150.66	150.7	1011300.0
2007-07-11 07:30:00	SPY	ETF	150.7	150.89	150.4	150.79	2014700.0
2007-07-11 08:00:00	SPY	ETF	150.55	151.34	150.46	150.84	5663500.0
2007-07-11 08:30:00	SPY	ETF	150.84	151.22	150.83	151.03	4565900.0
2007-07-11 09:00:00	SPY	ETF	150.97	150.99	150.73	150.73	2938600.0
2007-07-11 09:30:00	SPY	ETF	150.75	151.19	150.52	150.76	25022894.0
2007-07-11 10:00:00	SPY	ETF	150.76	151.44	150.54	151.33	26488000.0
2007-07-11 10:30:00	SPY	ETF	151.33	151.43	151.0	151.39	11900100.0
2007-07-11 11:00:00	SPY	ETF	151.38	151.8	151.38	151.64	12672360.0
2007-07-11 11:30:00	SPY	ETF	151.64	151.78	151.43	151.58	5907900.0
2007-07-11 12:00:00	SPY	ETF	151.59	151.75	151.35	151.53	5803363.0
2007-07-11 12:30:00	SPY	ETF	151.53	151.63	151.34	151.46	4928500.0
2007-07-11 13:00:00	SPY	ETF	151.45	151.6	151.43	151.55	2019100.0
2007-07-11 13:30:00	SPY	ETF	151.56	151.89	151.39	151.4	10072400.0
2007-07-11 14:00:00	SPY	ETF	151.41	151.64	151.15	151.57	11202100.0
2007-07-11 14:30:00	SPY	ETF	151.57	151.63	151.04	151.2	12331500.0
2007-07-11 15:00:00	SPY	ETF	151.2	151.59	151.12	151.57	7615900.0
2007-07-11 15:30:00	SPY	ETF	151.56	151.87	151.45	151.83	12622000.0
2007-07-11 16:00:00	SPY	ETF	151.83	152.09	151.48	152.05	2498600.0
2007-07-11 16:30:00	SPY	ETF	152.05	152.16	150.9463	152.13	3810800.0
2007-07-11 17:00:00	SPY	ETF	152.13	152.16	152.03	152.13	1908500.0
2007-07-11 17:30:00	SPY	ETF	152.12	152.18	152.1	152.1	235400.0
2007-07-11 18:00:00	SPY	ETF	152.12	152.12	152.08	152.1	15300.0
2007-07-11 18:30:00	SPY	ETF	152.15	152.35	152.15	152.19	26300.0
2007-07-11 19:00:00	SPY	ETF	152.2	152.25	152.2	152.24	38000.0
2007-07-11 19:30:00	SPY	ETF	152.26	152.26	152.24	152.24	10200.0
2007-07-11 07:00:00	QQQ	ETF	48.5	48.5	48.39	48.42	227060.0
2007-07-11 07:30:00	QQQ	ETF	48.41	48.48	48.29	48.45	1030357.0
2007-07-11 08:00:00	QQQ	ETF	48.45	48.48	48.38	48.43	722093.0
2007-07-11 08:30:00	QQQ	ETF	48.43	48.53	48.42	48.44	1964719.0
2007-07-11 09:00:00	QQQ	ETF	48.44	48.45	48.36	48.37	667754.0
2007-07-11 09:30:00	QQQ	ETF	48.37	48.57	48.32	48.38	12913492.0
2007-07-11 10:00:00	QQQ	ETF	48.38	48.64	48.33	48.59	11111040.0
2007-07-11 10:30:00	QQQ	ETF	48.59	48.63	48.53	48.61	7660364.0
2007-07-11 11:00:00	QQQ	ETF	48.61	48.7	48.57	48.66	6505847.0
2007-07-11 11:30:00	QQQ	ETF	48.6599	48.67	48.6	48.64	6263373.0
2007-07-11 12:00:00	QQQ	ETF	48.65	48.72	48.64	48.7	3730184.0
2007-07-11 12:30:00	QQQ	ETF	48.7	48.71	48.62	48.6494	3316481.0
2007-07-11 13:00:00	QQQ	ETF	48.65	48.7	48.62	48.66	3577493.0
2007-07-11 13:30:00	QQQ	ETF	48.668	48.78	48.65	48.66	7974014.0
2007-07-11 14:00:00	QQQ	ETF	48.66	48.73	48.58	48.71	5260480.0
2007-07-11 14:30:00	QQQ	ETF	48.71	48.72	48.54	48.595	6921977.0
2007-07-11 15:00:00	QQQ	ETF	48.59	48.75	48.58	48.75	5173556.0
2007-07-11 15:30:00	QQQ	ETF	48.74	48.81	48.69	48.8	8356780.0

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

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