PREVIEW / etf_5min / 2007-06-22

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-06-22.parquet
  size:    334 KB
  rows:    16,949

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-06-22 04:05:00	SPY	ETF	151.51	151.51	151.51	151.51	6200.0
2007-06-22 06:00:00	SPY	ETF	151.28	151.28	151.28	151.28	2400.0
2007-06-22 06:05:00	SPY	ETF	151.25	151.27	151.25	151.27	29900.0
2007-06-22 06:10:00	SPY	ETF	151.37	151.37	151.37	151.37	2000.0
2007-06-22 06:15:00	SPY	ETF	151.38	151.38	151.38	151.38	5000.0
2007-06-22 06:20:00	SPY	ETF	151.39	151.4	151.36	151.36	14800.0
2007-06-22 06:25:00	SPY	ETF	151.34	151.34	151.34	151.34	5000.0
2007-06-22 06:50:00	SPY	ETF	151.55	151.55	151.55	151.55	5000.0
2007-06-22 06:55:00	SPY	ETF	151.57	151.57	151.57	151.57	1000.0
2007-06-22 07:00:00	SPY	ETF	151.57	151.57	151.55	151.55	2000.0
2007-06-22 07:05:00	SPY	ETF	151.58	151.6	151.52	151.6	29700.0
2007-06-22 07:10:00	SPY	ETF	151.6	151.65	151.6	151.65	94400.0
2007-06-22 07:15:00	SPY	ETF	151.65	151.67	151.62	151.64	76200.0
2007-06-22 07:20:00	SPY	ETF	151.66	151.67	151.64	151.65	11100.0
2007-06-22 07:25:00	SPY	ETF	151.68	151.72	151.68	151.72	58900.0
2007-06-22 07:30:00	SPY	ETF	151.71	151.75	151.65	151.69	244600.0
2007-06-22 07:35:00	SPY	ETF	151.63	151.63	151.6	151.6	15000.0
2007-06-22 07:40:00	SPY	ETF	151.67	151.67	151.61	151.61	10700.0
2007-06-22 07:45:00	SPY	ETF	151.59	151.59	151.47	151.52	29700.0
2007-06-22 07:50:00	SPY	ETF	151.5	151.53	151.48	151.49	288400.0
2007-06-22 07:55:00	SPY	ETF	151.48	151.48	151.27	151.3	65000.0
2007-06-22 08:00:00	SPY	ETF	151.28	151.55	151.28	151.48	549300.0
2007-06-22 08:05:00	SPY	ETF	151.52	151.52	151.45	151.5	143100.0
2007-06-22 08:10:00	SPY	ETF	151.48	151.51	151.48	151.51	3900.0
2007-06-22 08:15:00	SPY	ETF	151.52	151.54	151.44	151.47	209400.0
2007-06-22 08:20:00	SPY	ETF	151.48	151.49	151.26	151.31	101400.0
2007-06-22 08:25:00	SPY	ETF	151.33	151.41	151.3	151.36	74900.0
2007-06-22 08:30:00	SPY	ETF	151.39	151.47	151.38	151.46	96100.0
2007-06-22 08:35:00	SPY	ETF	151.42	151.54	151.4	151.54	323300.0
2007-06-22 08:40:00	SPY	ETF	151.53	151.56	151.49	151.52	187400.0
2007-06-22 08:45:00	SPY	ETF	151.51	151.58	151.51	151.54	173200.0
2007-06-22 08:50:00	SPY	ETF	151.52	151.58	151.52	151.55	314900.0
2007-06-22 08:55:00	SPY	ETF	151.56	151.57	151.5	151.54	220600.0
2007-06-22 09:00:00	SPY	ETF	151.54	151.54	151.32	151.49	65300.0
2007-06-22 09:05:00	SPY	ETF	151.48	151.5	151.42	151.45	36700.0
2007-06-22 09:10:00	SPY	ETF	151.45	151.48	151.41	151.48	32600.0
2007-06-22 09:15:00	SPY	ETF	151.46	151.47	151.44	151.47	10400.0
2007-06-22 09:20:00	SPY	ETF	151.47	151.51	151.44	151.46	127200.0
2007-06-22 09:25:00	SPY	ETF	151.47	151.54	151.39	151.5	405500.0
2007-06-22 09:30:00	SPY	ETF	151.52	151.52	151.27	151.49	3247300.0
2007-06-22 09:35:00	SPY	ETF	151.49	151.77	151.39	151.7	3057897.0
2007-06-22 09:40:00	SPY	ETF	151.7	151.71	151.32	151.36	3411461.0
2007-06-22 09:45:00	SPY	ETF	151.36	151.4	151.1	151.25	3929431.0
2007-06-22 09:50:00	SPY	ETF	151.28	151.43	151.25	151.4	2175206.0
2007-06-22 09:55:00	SPY	ETF	151.4	151.55	151.3	151.47	1465570.0
2007-06-22 10:00:00	SPY	ETF	151.47	151.48	151.18	151.24	2281600.0
2007-06-22 10:05:00	SPY	ETF	151.24	151.3	151.07	151.25	3653819.0
2007-06-22 10:10:00	SPY	ETF	151.25	151.29	151.06	151.2	2943700.0
2007-06-22 10:15:00	SPY	ETF	151.2	151.31	151.14	151.28	2495000.0
2007-06-22 10:20:00	SPY	ETF	151.28	151.37	151.25	151.32	1338667.0

> showing 50 of 16,949 rows — these rows as CSV

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