PREVIEW / etf_30min / 2007-07-30

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-30.parquet
  size:    132 KB
  rows:    4,832

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-30 04:00:00	SPY	ETF	146.04	146.09	146.04	146.09	4700.0
2007-07-30 05:00:00	SPY	ETF	145.67	145.83	145.65	145.83	17100.0
2007-07-30 06:00:00	SPY	ETF	145.64	145.72	145.45	145.46	371900.0
2007-07-30 06:30:00	SPY	ETF	145.46	145.46	144.9	145.2	619800.0
2007-07-30 07:00:00	SPY	ETF	145.36	145.6	145.1	145.15	1483600.0
2007-07-30 07:30:00	SPY	ETF	145.14	145.48	145.13	145.27	1170200.0
2007-07-30 08:00:00	SPY	ETF	145.3	146.0	144.98	145.64	4978500.0
2007-07-30 08:30:00	SPY	ETF	145.64	146.0	145.64	145.9	4963400.0
2007-07-30 09:00:00	SPY	ETF	145.89	146.12	145.53	145.9	3498362.0
2007-07-30 09:30:00	SPY	ETF	145.93	146.33	145.33	146.06	39206712.0
2007-07-30 10:00:00	SPY	ETF	146.0499	146.72	145.86	146.54	21260434.0
2007-07-30 10:30:00	SPY	ETF	146.54	146.56	145.88	146.05	18819750.0
2007-07-30 11:00:00	SPY	ETF	146.05	146.42	145.62	145.98	18945261.0
2007-07-30 11:30:00	SPY	ETF	145.99	146.07	145.38	145.9	17401556.0
2007-07-30 12:00:00	SPY	ETF	145.91	146.51	145.6	145.77	10140182.0
2007-07-30 12:30:00	SPY	ETF	145.77	147.09	145.77	146.51	12473329.0
2007-07-30 13:00:00	SPY	ETF	146.51	146.81	146.48	146.58	10318155.0
2007-07-30 13:30:00	SPY	ETF	146.58	147.25	145.29	147.05	21046977.0
2007-07-30 14:00:00	SPY	ETF	147.05	147.3	146.36	146.99	13027393.0
2007-07-30 14:30:00	SPY	ETF	146.99	147.31	146.8	147.2	13294297.0
2007-07-30 15:00:00	SPY	ETF	147.21	147.81	147.07	147.58	21170115.0
2007-07-30 15:30:00	SPY	ETF	147.59	147.77	147.05	147.27	24088399.0
2007-07-30 16:00:00	SPY	ETF	147.26	147.55	147.21	147.4	6674800.0
2007-07-30 16:30:00	SPY	ETF	147.4	147.67	147.2	147.55	1752600.0
2007-07-30 17:00:00	SPY	ETF	147.59	147.61	147.45	147.52	169700.0
2007-07-30 17:30:00	SPY	ETF	147.55	147.55	147.5	147.51	8882900.0
2007-07-30 18:00:00	SPY	ETF	147.5	147.56	147.32	147.39	599200.0
2007-07-30 18:30:00	SPY	ETF	147.42	147.44	147.31	147.32	75700.0
2007-07-30 19:00:00	SPY	ETF	147.33	147.33	147.28	147.29	32400.0
2007-07-30 19:30:00	SPY	ETF	147.3	147.38	147.26	147.27	764400.0
2007-07-30 04:00:00	QQQ	ETF	48.19	48.19	48.19	48.19	2000.0
2007-07-30 04:30:00	QQQ	ETF	48.14	48.14	48.14	48.14	1000.0
2007-07-30 05:30:00	QQQ	ETF	48.16	48.16	48.08	48.08	11000.0
2007-07-30 06:00:00	QQQ	ETF	48.13	48.13	48.05	48.05	600.0
2007-07-30 06:30:00	QQQ	ETF	47.96	47.96	47.85	47.85	10900.0
2007-07-30 07:00:00	QQQ	ETF	48.07	48.1	47.92	47.92	189384.0
2007-07-30 07:30:00	QQQ	ETF	47.93	48.05	47.93	48.0	128783.0
2007-07-30 08:00:00	QQQ	ETF	48.01	48.17	47.92	48.11	893545.0
2007-07-30 08:30:00	QQQ	ETF	48.11	48.22	48.11	48.22	1140901.0
2007-07-30 09:00:00	QQQ	ETF	48.21	48.28	48.2	48.21	879134.0
2007-07-30 09:30:00	QQQ	ETF	48.21	48.39	48.03	48.3	26113185.0
2007-07-30 10:00:00	QQQ	ETF	48.31	48.44	48.13	48.28	17569093.0
2007-07-30 10:30:00	QQQ	ETF	48.29	48.29	48.04	48.16	12395995.0
2007-07-30 11:00:00	QQQ	ETF	48.16	48.27	47.99	48.1485	13761202.0
2007-07-30 11:30:00	QQQ	ETF	48.15	48.18	47.95	48.14	8934498.0
2007-07-30 12:00:00	QQQ	ETF	48.14	48.17	48.01	48.1	7581468.0
2007-07-30 12:30:00	QQQ	ETF	48.101	48.39	48.1	48.35	10371051.0
2007-07-30 13:00:00	QQQ	ETF	48.36	48.51	48.32	48.38	11437272.0
2007-07-30 13:30:00	QQQ	ETF	48.38	48.6	48.28	48.52	13822100.0
2007-07-30 14:00:00	QQQ	ETF	48.52	48.59	48.45	48.49	5158211.0

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

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