PREVIEW / etf_30min / 2007-08-03

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-03.parquet
  size:    129 KB
  rows:    4,738

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-08-03 06:00:00	SPY	ETF	147.59	147.59	146.65	146.65	500.0
2007-08-03 06:30:00	SPY	ETF	147.52	147.56	147.52	147.56	17500.0
2007-08-03 07:00:00	SPY	ETF	147.51	147.51	147.44	147.45	12500.0
2007-08-03 07:30:00	SPY	ETF	147.48	147.69	147.48	147.56	320400.0
2007-08-03 08:00:00	SPY	ETF	147.64	147.9	147.54	147.82	2074500.0
2007-08-03 08:30:00	SPY	ETF	147.82	147.82	146.92	147.43	10109400.0
2007-08-03 09:00:00	SPY	ETF	147.44	147.6	147.15	147.25	886500.0
2007-08-03 09:30:00	SPY	ETF	147.28	147.58	146.36	146.53	34276206.0
2007-08-03 10:00:00	SPY	ETF	146.53	146.91	145.84	146.31	33904499.0
2007-08-03 10:30:00	SPY	ETF	146.3	146.45	145.64	146.08	26615610.0
2007-08-03 11:00:00	SPY	ETF	146.09	146.55	145.99	146.36	17212280.0
2007-08-03 11:30:00	SPY	ETF	146.35	146.74	146.13	146.47	21726707.0
2007-08-03 12:00:00	SPY	ETF	146.47	146.92	146.23	146.31	14768946.0
2007-08-03 12:30:00	SPY	ETF	146.31	147.3005	145.9	146.05	12619799.0
2007-08-03 13:00:00	SPY	ETF	146.04	147.3005	145.91	146.23	8759588.0
2007-08-03 13:30:00	SPY	ETF	146.22	146.57	145.98	146.41	13723799.0
2007-08-03 14:00:00	SPY	ETF	146.4	146.78	145.11	145.13	33598800.0
2007-08-03 14:30:00	SPY	ETF	145.13	145.65	145.07	145.29	26131078.0
2007-08-03 15:00:00	SPY	ETF	145.29	145.92	144.42	144.44	33956546.0
2007-08-03 15:30:00	SPY	ETF	144.45	145.2	143.24	143.35	46967278.0
2007-08-03 16:00:00	SPY	ETF	143.34	146.4	143.2	143.85	9927177.0
2007-08-03 16:30:00	SPY	ETF	143.85	147.2997	143.42	143.63	1535300.0
2007-08-03 17:00:00	SPY	ETF	143.65	147.2997	143.65	143.73	1277600.0
2007-08-03 17:30:00	SPY	ETF	143.73	143.8	143.7	143.72	114000.0
2007-08-03 18:00:00	SPY	ETF	143.73	144.36	143.65	143.65	128100.0
2007-08-03 18:30:00	SPY	ETF	143.69	143.7	143.63	143.64	4800.0
2007-08-03 19:00:00	SPY	ETF	143.63	143.7	143.57	143.68	8200.0
2007-08-03 19:30:00	SPY	ETF	143.63	143.7	143.55	143.7	9900.0
2007-08-03 07:00:00	QQQ	ETF	48.29	48.29	48.27	48.28	68400.0
2007-08-03 07:30:00	QQQ	ETF	48.28	48.36	48.28	48.33	158973.0
2007-08-03 08:00:00	QQQ	ETF	48.33	48.43	48.3	48.38	992285.0
2007-08-03 08:30:00	QQQ	ETF	48.35	48.37	48.22	48.32	4973966.0
2007-08-03 09:00:00	QQQ	ETF	48.32	48.34	48.23	48.24	1320507.0
2007-08-03 09:30:00	QQQ	ETF	48.25	48.31	48.0	48.05	11626617.0
2007-08-03 10:00:00	QQQ	ETF	48.06	48.08	47.87	48.05	14140679.0
2007-08-03 10:30:00	QQQ	ETF	48.05	48.09	47.85	47.96	11942956.0
2007-08-03 11:00:00	QQQ	ETF	47.95	48.08	47.91	48.04	6740285.0
2007-08-03 11:30:00	QQQ	ETF	48.04	48.14	47.97	48.09	8851091.0
2007-08-03 12:00:00	QQQ	ETF	48.09	48.29	48.05	48.09	13796341.0
2007-08-03 12:30:00	QQQ	ETF	48.09	48.13	47.95	47.98	6593840.0
2007-08-03 13:00:00	QQQ	ETF	47.99	48.08	47.94	48.03	4740495.0
2007-08-03 13:30:00	QQQ	ETF	48.03	48.12	47.98	48.08	3837723.0
2007-08-03 14:00:00	QQQ	ETF	48.09	48.2	47.78	47.78	10182657.0
2007-08-03 14:30:00	QQQ	ETF	47.78	47.93	47.7	47.79	10932324.0
2007-08-03 15:00:00	QQQ	ETF	47.79	47.84	47.55	47.5599	13511813.0
2007-08-03 15:30:00	QQQ	ETF	47.55	47.69	47.15	47.17	22501214.0
2007-08-03 16:00:00	QQQ	ETF	47.17	47.43	47.154	47.33	4272303.0
2007-08-03 16:30:00	QQQ	ETF	47.37	47.37	47.31	47.34	24516.0
2007-08-03 17:00:00	QQQ	ETF	47.32	47.42	47.31	47.38	296831.0
2007-08-03 17:30:00	QQQ	ETF	47.39	47.39	47.34	47.36	10000.0

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

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