PREVIEW / etf_30min / 2007-08-01

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-01.parquet
  size:    137 KB
  rows:    5,003

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-01 04:00:00	SPY	ETF	144.41	144.41	143.97	143.97	5300.0
2007-08-01 04:30:00	SPY	ETF	143.85	143.97	143.78	143.94	6200.0
2007-08-01 05:00:00	SPY	ETF	144.05	144.11	144.05	144.11	1200.0
2007-08-01 05:30:00	SPY	ETF	144.06	144.48	144.06	144.48	1800.0
2007-08-01 06:00:00	SPY	ETF	144.53	144.69	144.3	144.5	161900.0
2007-08-01 06:30:00	SPY	ETF	144.5	144.58	144.05	144.47	238600.0
2007-08-01 07:00:00	SPY	ETF	144.5	145.2	144.48	145.01	2247300.0
2007-08-01 07:30:00	SPY	ETF	145.0	145.0	144.38	144.62	1852300.0
2007-08-01 08:00:00	SPY	ETF	144.66	145.15	143.45	144.92	7702400.0
2007-08-01 08:30:00	SPY	ETF	144.92	145.45	144.78	145.27	6401500.0
2007-08-01 09:00:00	SPY	ETF	145.26	145.37	144.33	145.24	3044400.0
2007-08-01 09:30:00	SPY	ETF	145.21	146.48	144.59	145.21	58638095.0
2007-08-01 10:00:00	SPY	ETF	145.215	146.3	145.13	145.63	43145906.0
2007-08-01 10:30:00	SPY	ETF	145.64	145.73	144.59	144.73	41837165.0
2007-08-01 11:00:00	SPY	ETF	144.73	145.65	144.3	145.03	40770690.0
2007-08-01 11:30:00	SPY	ETF	145.02	145.85	144.95	145.81	17579756.0
2007-08-01 12:00:00	SPY	ETF	145.8	146.4	145.32	146.24	27223425.0
2007-08-01 12:30:00	SPY	ETF	146.24	146.42	145.51	145.74	14770239.0
2007-08-01 13:00:00	SPY	ETF	145.74	146.2	144.6	144.98	23656959.0
2007-08-01 13:30:00	SPY	ETF	144.98	145.52	144.78	145.11	14330596.0
2007-08-01 14:00:00	SPY	ETF	145.11	145.42	144.7	144.9	17505980.0
2007-08-01 14:30:00	SPY	ETF	144.9	145.3	144.0	144.49	30737291.0
2007-08-01 15:00:00	SPY	ETF	144.49	144.83	143.95	144.52	35485939.0
2007-08-01 15:30:00	SPY	ETF	144.53	147.01	144.32	146.61	58032903.0
2007-08-01 16:00:00	SPY	ETF	146.55	146.81	145.153	146.4	8161700.0
2007-08-01 16:30:00	SPY	ETF	146.43	146.82	146.23	146.69	582900.0
2007-08-01 17:00:00	SPY	ETF	146.69	146.92	145.5295	146.85	2283100.0
2007-08-01 17:30:00	SPY	ETF	146.85	146.9	146.75	146.79	44400.0
2007-08-01 18:00:00	SPY	ETF	146.83	146.88	146.77	146.78	33900.0
2007-08-01 18:30:00	SPY	ETF	146.8	146.8	146.71	146.71	10400.0
2007-08-01 19:00:00	SPY	ETF	146.74	146.82	146.74	146.82	1600.0
2007-08-01 19:30:00	SPY	ETF	146.8	146.82	146.73	146.76	6500.0
2007-08-01 04:00:00	QQQ	ETF	47.18	47.18	47.1	47.1	1600.0
2007-08-01 04:30:00	QQQ	ETF	47.1	47.1	47.04	47.04	1100.0
2007-08-01 06:00:00	QQQ	ETF	47.26	47.26	47.26	47.26	300.0
2007-08-01 06:30:00	QQQ	ETF	47.2	47.2	47.2	47.2	300.0
2007-08-01 07:00:00	QQQ	ETF	47.26	47.45	47.25	47.42	385762.0
2007-08-01 07:30:00	QQQ	ETF	47.39	47.39	47.22	47.31	337705.0
2007-08-01 08:00:00	QQQ	ETF	47.32	47.37	47.18	47.32	1435795.0
2007-08-01 08:30:00	QQQ	ETF	47.32	47.47	47.28	47.42	1601291.0
2007-08-01 09:00:00	QQQ	ETF	47.41	47.47	47.34	47.41	1149667.0
2007-08-01 09:30:00	QQQ	ETF	47.39	47.81	47.04	47.36	39388656.0
2007-08-01 10:00:00	QQQ	ETF	47.35	47.7	47.24	47.36	30331374.0
2007-08-01 10:30:00	QQQ	ETF	47.36	47.65	47.06	47.09	25756657.0
2007-08-01 11:00:00	QQQ	ETF	47.0985	47.34	47.0	47.21	18687139.0
2007-08-01 11:30:00	QQQ	ETF	47.21	47.64	47.21	47.62	18205979.0
2007-08-01 12:00:00	QQQ	ETF	47.62	47.77	47.48	47.7	9500594.0
2007-08-01 12:30:00	QQQ	ETF	47.7	47.78	47.45	47.54	10845995.0
2007-08-01 13:00:00	QQQ	ETF	47.53	47.54	47.15	47.28	23821006.0
2007-08-01 13:30:00	QQQ	ETF	47.28	47.49	47.26	47.43	11461679.0

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

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