PREVIEW / etf_30min / 2007-10-23

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-23.parquet
  size:    134 KB
  rows:    5,078

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-23 04:30:00	SPY	ETF	151.1	151.1	151.1	151.1	100.0
2007-10-23 05:30:00	SPY	ETF	151.03	151.03	151.03	151.03	2000.0
2007-10-23 06:00:00	SPY	ETF	151.15	151.15	151.15	151.15	2000.0
2007-10-23 06:30:00	SPY	ETF	151.3	151.43	151.26	151.4	136700.0
2007-10-23 07:00:00	SPY	ETF	151.37	151.39	150.99	151.01	405000.0
2007-10-23 07:30:00	SPY	ETF	151.01	151.15	150.93	150.98	311600.0
2007-10-23 08:00:00	SPY	ETF	150.97	151.17	150.96	151.14	1905700.0
2007-10-23 08:30:00	SPY	ETF	151.1	151.41	151.1	151.37	785400.0
2007-10-23 09:00:00	SPY	ETF	151.39	151.5	151.3	151.31	2064000.0
2007-10-23 09:30:00	SPY	ETF	151.3	151.52	151.15	151.27	15606122.0
2007-10-23 10:00:00	SPY	ETF	151.29	151.61	151.1	151.33	12991400.0
2007-10-23 10:30:00	SPY	ETF	151.33	151.5	150.9	150.9	10212000.0
2007-10-23 11:00:00	SPY	ETF	150.9	150.94	150.25	150.4405	23660000.0
2007-10-23 11:30:00	SPY	ETF	150.45	150.94	150.27	150.78	15765700.0
2007-10-23 12:00:00	SPY	ETF	150.79	150.97	150.55	150.74	7090600.0
2007-10-23 12:30:00	SPY	ETF	150.74	150.94	150.63	150.66	4272900.0
2007-10-23 13:00:00	SPY	ETF	150.66	151.13	150.53	150.86	8335600.0
2007-10-23 13:30:00	SPY	ETF	150.87	151.04	150.73	150.9	7801600.0
2007-10-23 14:00:00	SPY	ETF	150.91	151.5	150.8	151.31	14127384.0
2007-10-23 14:30:00	SPY	ETF	151.31	151.5	150.99	151.08	10704236.0
2007-10-23 15:00:00	SPY	ETF	151.08	151.3	150.86	151.25	11151320.0
2007-10-23 15:30:00	SPY	ETF	151.248	151.95	151.22	151.95	19412800.0
2007-10-23 16:00:00	SPY	ETF	151.94	151.95	150.802	151.4	2468900.0
2007-10-23 16:30:00	SPY	ETF	151.4	151.95	151.24	151.25	7619900.0
2007-10-23 17:00:00	SPY	ETF	151.25	151.29	149.98	151.24	731000.0
2007-10-23 17:30:00	SPY	ETF	151.25	151.31	151.22	151.31	65700.0
2007-10-23 18:00:00	SPY	ETF	151.25	151.32	151.2	151.32	27600.0
2007-10-23 18:30:00	SPY	ETF	151.32	151.32	151.26	151.27	45600.0
2007-10-23 19:00:00	SPY	ETF	151.28	151.35	151.26	151.32	32400.0
2007-10-23 19:30:00	SPY	ETF	151.32	151.32	151.26	151.3	25800.0
2007-10-23 05:00:00	QQQ	ETF	53.37	53.37	53.37	53.37	2000.0
2007-10-23 06:00:00	QQQ	ETF	53.47	53.47	53.44	53.44	29500.0
2007-10-23 06:30:00	QQQ	ETF	53.48	53.51	53.48	53.51	4100.0
2007-10-23 07:00:00	QQQ	ETF	53.49	53.52	53.44	53.44	260938.0
2007-10-23 07:30:00	QQQ	ETF	53.44	53.46	53.42	53.45	476815.0
2007-10-23 08:00:00	QQQ	ETF	53.44	53.59	53.44	53.53	2896756.0
2007-10-23 08:30:00	QQQ	ETF	53.53	53.61	53.53	53.61	620776.0
2007-10-23 09:00:00	QQQ	ETF	53.6	53.71	53.59	53.62	3389514.0
2007-10-23 09:30:00	QQQ	ETF	53.61	53.7	53.44	53.53	24568725.0
2007-10-23 10:00:00	QQQ	ETF	53.53	53.73	53.5	53.68	12019182.0
2007-10-23 10:30:00	QQQ	ETF	53.68	53.75	53.54	53.55	7774489.0
2007-10-23 11:00:00	QQQ	ETF	53.55	53.6	53.34	53.44	12413737.0
2007-10-23 11:30:00	QQQ	ETF	53.44	53.64	53.34	53.559	8145885.0
2007-10-23 12:00:00	QQQ	ETF	53.56	53.63	53.46	53.5501	3099578.0
2007-10-23 12:30:00	QQQ	ETF	53.5599	53.64	53.54	53.5581	3032022.0
2007-10-23 13:00:00	QQQ	ETF	53.55	53.66	53.45	53.5995	4707389.0
2007-10-23 13:30:00	QQQ	ETF	53.59	53.71	53.57	53.63	5897132.0
2007-10-23 14:00:00	QQQ	ETF	53.64	53.98	53.63	53.909	9947005.0
2007-10-23 14:30:00	QQQ	ETF	53.9	54.07	53.88	53.97	14681497.0
2007-10-23 15:00:00	QQQ	ETF	53.96	54.1089	53.92	54.06	12569087.0

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

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