PREVIEW / etf_30min / 2007-05-16

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-16.parquet
  size:    115 KB
  rows:    4,317

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-05-16 05:30:00	SPY	ETF	150.55	150.55	150.55	150.55	1000.0
2007-05-16 06:00:00	SPY	ETF	150.53	150.56	150.52	150.56	8000.0
2007-05-16 06:30:00	SPY	ETF	150.59	150.59	150.59	150.59	5000.0
2007-05-16 07:00:00	SPY	ETF	150.5	150.74	150.5	150.71	121000.0
2007-05-16 07:30:00	SPY	ETF	150.67	150.82	150.67	150.8	252800.0
2007-05-16 08:00:00	SPY	ETF	150.72	150.91	150.72	150.86	959200.0
2007-05-16 08:30:00	SPY	ETF	150.9	151.09	150.69	150.73	1567400.0
2007-05-16 09:00:00	SPY	ETF	150.73	150.97	150.72	150.8	1184200.0
2007-05-16 09:30:00	SPY	ETF	150.8	151.1	150.76	150.9	15996444.0
2007-05-16 10:00:00	SPY	ETF	150.89	151.14	150.82	150.97	10249015.0
2007-05-16 10:30:00	SPY	ETF	150.97	150.97	150.57	150.66	10586200.0
2007-05-16 11:00:00	SPY	ETF	150.67	151.0	150.38	150.62	10349273.0
2007-05-16 11:30:00	SPY	ETF	150.61	150.96	150.6	150.9	8335525.0
2007-05-16 12:00:00	SPY	ETF	150.89	150.94	150.63	150.73	5334900.0
2007-05-16 12:30:00	SPY	ETF	150.73	150.91	150.5	150.9	3536800.0
2007-05-16 13:00:00	SPY	ETF	150.91	150.94	150.69	150.8	3900300.0
2007-05-16 13:30:00	SPY	ETF	150.81	151.2	150.81	151.0	7550697.0
2007-05-16 14:00:00	SPY	ETF	151.0	151.37	150.98	151.23	6626300.0
2007-05-16 14:30:00	SPY	ETF	151.24	151.3	151.12	151.26	3332600.0
2007-05-16 15:00:00	SPY	ETF	151.25	151.36	151.11	151.29	6556900.0
2007-05-16 15:30:00	SPY	ETF	151.3	151.63	151.3	151.61	12862573.0
2007-05-16 16:00:00	SPY	ETF	151.6	151.67	151.55	151.6	2233200.0
2007-05-16 16:30:00	SPY	ETF	151.6	151.6	151.52	151.54	414100.0
2007-05-16 17:00:00	SPY	ETF	151.52	151.54	151.36	151.42	199300.0
2007-05-16 17:30:00	SPY	ETF	151.42	151.44	151.41	151.44	7800.0
2007-05-16 18:00:00	SPY	ETF	151.44	151.44	151.42	151.44	338100.0
2007-05-16 18:30:00	SPY	ETF	151.44	151.47	151.44	151.47	7200.0
2007-05-16 19:00:00	SPY	ETF	151.47	151.47	151.47	151.47	500.0
2007-05-16 19:30:00	SPY	ETF	151.44	151.44	151.43	151.43	1000.0
2007-05-16 07:00:00	QQQ	ETF	46.14	46.2	46.13	46.18	211058.0
2007-05-16 07:30:00	QQQ	ETF	46.17	46.24	46.16	46.23	566991.0
2007-05-16 08:00:00	QQQ	ETF	46.2	46.31	46.19	46.25	913966.0
2007-05-16 08:30:00	QQQ	ETF	46.26	46.28	46.18	46.19	745730.0
2007-05-16 09:00:00	QQQ	ETF	46.19	46.26	46.16	46.21	943206.0
2007-05-16 09:30:00	QQQ	ETF	46.21	46.33	46.19	46.25	20148435.0
2007-05-16 10:00:00	QQQ	ETF	46.24	46.32	46.1699	46.2825	9001901.0
2007-05-16 10:30:00	QQQ	ETF	46.29	46.29	46.04	46.1001	10548399.0
2007-05-16 11:00:00	QQQ	ETF	46.1	46.14	45.91	46.05	17165480.0
2007-05-16 11:30:00	QQQ	ETF	46.04	46.25	46.04	46.19	12585316.0
2007-05-16 12:00:00	QQQ	ETF	46.2	46.22	46.08	46.15	7403716.0
2007-05-16 12:30:00	QQQ	ETF	46.15	46.25	46.06	46.24	11582240.0
2007-05-16 13:00:00	QQQ	ETF	46.2386	46.25	46.116	46.2	7969569.0
2007-05-16 13:30:00	QQQ	ETF	46.21	46.31	46.2	46.25	9085735.0
2007-05-16 14:00:00	QQQ	ETF	46.25	46.39	46.23	46.32	7821245.0
2007-05-16 14:30:00	QQQ	ETF	46.3186	46.36	46.27	46.33	3673566.0
2007-05-16 15:00:00	QQQ	ETF	46.34	46.4	46.27	46.37	6090235.0
2007-05-16 15:30:00	QQQ	ETF	46.37	46.55	46.35	46.54	11898190.0
2007-05-16 16:00:00	QQQ	ETF	46.53	46.6	46.52	46.59	1679208.0
2007-05-16 16:30:00	QQQ	ETF	46.57	46.59	46.55	46.55	104258.0
2007-05-16 17:00:00	QQQ	ETF	46.55	46.57	46.52	46.52	188350.0

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

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