PREVIEW / etf_30min / 2007-10-31

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-31.parquet
  size:    136 KB
  rows:    5,086

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-10-31 04:30:00	SPY	ETF	153.28	153.28	153.28	153.28	100.0
2007-10-31 05:30:00	SPY	ETF	153.46	153.46	153.46	153.46	7000.0
2007-10-31 06:30:00	SPY	ETF	153.61	153.61	153.51	153.53	30000.0
2007-10-31 07:00:00	SPY	ETF	153.53	153.76	153.53	153.69	562700.0
2007-10-31 07:30:00	SPY	ETF	153.71	153.73	153.53	153.6	492800.0
2007-10-31 08:00:00	SPY	ETF	153.62	153.75	153.3	153.6	738100.0
2007-10-31 08:30:00	SPY	ETF	153.65	153.89	153.5	153.88	2359600.0
2007-10-31 09:00:00	SPY	ETF	153.86	153.98	153.74	153.98	2264400.0
2007-10-31 09:30:00	SPY	ETF	153.98	153.99	153.5199	153.68	12964205.0
2007-10-31 10:00:00	SPY	ETF	153.67	153.9	153.63	153.86	6238539.0
2007-10-31 10:30:00	SPY	ETF	153.85	154.11	153.75	153.93	10320936.0
2007-10-31 11:00:00	SPY	ETF	153.93	154.03	153.89	154.0	2619807.0
2007-10-31 11:30:00	SPY	ETF	154.0	154.18	153.97	154.15	4686168.0
2007-10-31 12:00:00	SPY	ETF	154.16	154.32	154.12	154.19	9127518.0
2007-10-31 12:30:00	SPY	ETF	154.18	154.27	154.11	154.16	6691083.0
2007-10-31 13:00:00	SPY	ETF	154.16	154.29	154.13	154.18	4282805.0
2007-10-31 13:30:00	SPY	ETF	154.2	154.3	154.0	154.18	7512176.0
2007-10-31 14:00:00	SPY	ETF	154.19	154.21	152.84	153.3	51489678.0
2007-10-31 14:30:00	SPY	ETF	153.3	155.27	153.23	154.94	41005184.0
2007-10-31 15:00:00	SPY	ETF	154.95	155.25	153.94	154.21	24631126.0
2007-10-31 15:30:00	SPY	ETF	154.21	154.88	154.12	154.8	18919724.0
2007-10-31 16:00:00	SPY	ETF	154.83	154.85	153.15	154.7	3623100.0
2007-10-31 16:30:00	SPY	ETF	154.69	154.87	154.65	154.87	2279800.0
2007-10-31 17:00:00	SPY	ETF	154.85	154.87	153.93	154.78	89300.0
2007-10-31 17:30:00	SPY	ETF	154.72	154.75	154.67	154.75	654300.0
2007-10-31 18:00:00	SPY	ETF	154.8	154.82	154.65	154.65	5500.0
2007-10-31 18:30:00	SPY	ETF	154.67	154.69	154.67	154.68	4200.0
2007-10-31 19:00:00	SPY	ETF	154.67	154.69	154.67	154.69	3300.0
2007-10-31 19:30:00	SPY	ETF	154.72	154.79	154.67	154.76	20200.0
2007-10-31 04:00:00	QQQ	ETF	54.31	54.31	54.31	54.31	100.0
2007-10-31 04:30:00	QQQ	ETF	54.29	54.29	54.29	54.29	100.0
2007-10-31 07:00:00	QQQ	ETF	54.41	54.42	54.41	54.42	1900.0
2007-10-31 07:30:00	QQQ	ETF	54.4	54.4	54.38	54.39	27700.0
2007-10-31 08:00:00	QQQ	ETF	54.4	54.44	54.36	54.36	312651.0
2007-10-31 08:30:00	QQQ	ETF	54.38	54.47	54.34	54.46	755508.0
2007-10-31 09:00:00	QQQ	ETF	54.46	54.5	54.44	54.46	1465393.0
2007-10-31 09:30:00	QQQ	ETF	54.46	54.47	54.2995	54.45	9434028.0
2007-10-31 10:00:00	QQQ	ETF	54.45	54.51	54.38	54.47	4478859.0
2007-10-31 10:30:00	QQQ	ETF	54.46	54.53	54.4	54.478	4765797.0
2007-10-31 11:00:00	QQQ	ETF	54.48	54.53	54.44	54.5	2745917.0
2007-10-31 11:30:00	QQQ	ETF	54.502	54.58	54.47	54.58	3709107.0
2007-10-31 12:00:00	QQQ	ETF	54.5702	54.66	54.5599	54.59	4707348.0
2007-10-31 12:30:00	QQQ	ETF	54.59	54.61	54.48	54.5	3612074.0
2007-10-31 13:00:00	QQQ	ETF	54.49	54.569	54.2669	54.54	7107886.0
2007-10-31 13:30:00	QQQ	ETF	54.54	54.57	54.41	54.508	6066441.0
2007-10-31 14:00:00	QQQ	ETF	54.5	54.52	54.04	54.27	31173055.0
2007-10-31 14:30:00	QQQ	ETF	54.28	55.07	54.26	54.96	29307937.0
2007-10-31 15:00:00	QQQ	ETF	54.95	54.99	54.67	54.74	17189861.0
2007-10-31 15:30:00	QQQ	ETF	54.73	55.02	54.69	55.02	15678917.0
2007-10-31 16:00:00	QQQ	ETF	55.01	55.07	54.16	54.92	9379512.0

> showing 50 of 5,086 rows — these rows as CSV

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