PREVIEW / etf_30min / 2007-11-01

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-01.parquet
  size:    147 KB
  rows:    5,386

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-11-01 04:00:00	SPY	ETF	154.5	154.5	154.34	154.34	400.0
2007-11-01 04:30:00	SPY	ETF	154.29	154.29	154.29	154.29	200.0
2007-11-01 05:00:00	SPY	ETF	154.4	154.4	154.23	154.23	2600.0
2007-11-01 05:30:00	SPY	ETF	154.35	154.35	154.32	154.32	13500.0
2007-11-01 06:00:00	SPY	ETF	154.27	154.32	154.22	154.32	17900.0
2007-11-01 06:30:00	SPY	ETF	154.32	154.45	154.32	154.4	5700.0
2007-11-01 07:00:00	SPY	ETF	154.43	154.43	154.22	154.27	296700.0
2007-11-01 07:30:00	SPY	ETF	154.22	154.27	154.04	154.12	922100.0
2007-11-01 08:00:00	SPY	ETF	154.1	154.65	153.67	153.8	5262700.0
2007-11-01 08:30:00	SPY	ETF	153.76	154.01	152.9	153.05	8905300.0
2007-11-01 09:00:00	SPY	ETF	153.04	154.48	153.0	153.33	3232700.0
2007-11-01 09:30:00	SPY	ETF	153.3	153.41	152.05	152.67	35644134.0
2007-11-01 10:00:00	SPY	ETF	152.67	152.78	151.75	152.34	40350532.0
2007-11-01 10:30:00	SPY	ETF	152.33	152.99	152.2	152.87	27341825.0
2007-11-01 11:00:00	SPY	ETF	152.88	152.89	152.45	152.85	11058284.0
2007-11-01 11:30:00	SPY	ETF	152.852	152.852	152.13	152.64	23770862.0
2007-11-01 12:00:00	SPY	ETF	152.65	153.11	152.49	152.76	16114881.0
2007-11-01 12:30:00	SPY	ETF	152.75	152.82	152.39	152.71	11294547.0
2007-11-01 13:00:00	SPY	ETF	152.73	152.94	152.5	152.5	10886309.0
2007-11-01 13:30:00	SPY	ETF	152.5	152.56	151.78	151.86	19172224.0
2007-11-01 14:00:00	SPY	ETF	151.86	152.28	151.19	151.91	18299681.0
2007-11-01 14:30:00	SPY	ETF	151.91	152.55	151.91	152.38	18095944.0
2007-11-01 15:00:00	SPY	ETF	152.38	152.51	151.0	151.17	27350454.0
2007-11-01 15:30:00	SPY	ETF	151.17	151.47	150.59	150.78	36725859.0
2007-11-01 16:00:00	SPY	ETF	150.78	154.3	150.76	151.1	5609600.0
2007-11-01 16:30:00	SPY	ETF	151.08	151.35	150.82	150.89	8531900.0
2007-11-01 17:00:00	SPY	ETF	150.88	150.91	150.71	150.75	143100.0
2007-11-01 17:30:00	SPY	ETF	150.74	150.8	150.7	150.78	29900.0
2007-11-01 18:00:00	SPY	ETF	150.74	150.88	150.74	150.83	76400.0
2007-11-01 18:30:00	SPY	ETF	150.89	151.04	150.84	151.04	4900.0
2007-11-01 19:00:00	SPY	ETF	151.0	151.13	151.0	151.13	10500.0
2007-11-01 19:30:00	SPY	ETF	151.09	151.15	150.94	151.03	59400.0
2007-11-01 05:00:00	QQQ	ETF	54.89	54.92	54.89	54.92	15100.0
2007-11-01 05:30:00	QQQ	ETF	54.92	54.95	54.92	54.94	75000.0
2007-11-01 06:00:00	QQQ	ETF	54.95	55.0	54.94	55.0	127300.0
2007-11-01 06:30:00	QQQ	ETF	55.0	55.0	54.99	54.99	13700.0
2007-11-01 07:00:00	QQQ	ETF	55.01	55.01	54.92	54.92	73882.0
2007-11-01 07:30:00	QQQ	ETF	54.93	54.93	54.86	54.91	172744.0
2007-11-01 08:00:00	QQQ	ETF	54.89	54.94	54.75	54.78	746561.0
2007-11-01 08:30:00	QQQ	ETF	54.78	54.87	54.55	54.61	1948941.0
2007-11-01 09:00:00	QQQ	ETF	54.64	54.69	54.56	54.65	4010720.0
2007-11-01 09:30:00	QQQ	ETF	54.65	54.77	54.41	54.62	24539097.0
2007-11-01 10:00:00	QQQ	ETF	54.61	54.67	54.24	54.55	19405073.0
2007-11-01 10:30:00	QQQ	ETF	54.56	54.68	54.5	54.642	10894337.0
2007-11-01 11:00:00	QQQ	ETF	54.64	54.68	54.48	54.65	6232699.0
2007-11-01 11:30:00	QQQ	ETF	54.652	54.652	54.43	54.59	8598269.0
2007-11-01 12:00:00	QQQ	ETF	54.59	54.68	54.53	54.53	8001498.0
2007-11-01 12:30:00	QQQ	ETF	54.53	54.62	54.5	54.61	5317960.0
2007-11-01 13:00:00	QQQ	ETF	54.61	54.75	54.56	54.56	6626897.0
2007-11-01 13:30:00	QQQ	ETF	54.57	54.6	54.28	54.33	11125369.0

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

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