PREVIEW / etf_5min / 2007-06-27

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-06-27.parquet
  size:    355 KB
  rows:    16,813

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-27 04:20:00	SPY	ETF	148.5	148.5	148.46	148.46	1400.0
2007-06-27 05:10:00	SPY	ETF	148.4	148.4	148.4	148.4	2000.0
2007-06-27 06:15:00	SPY	ETF	148.54	148.54	148.54	148.54	5000.0
2007-06-27 06:30:00	SPY	ETF	148.59	148.59	148.59	148.59	2500.0
2007-06-27 06:35:00	SPY	ETF	148.51	148.51	148.51	148.51	2500.0
2007-06-27 06:45:00	SPY	ETF	148.6	148.6	148.6	148.6	2400.0
2007-06-27 06:55:00	SPY	ETF	148.63	148.7	148.63	148.7	11100.0
2007-06-27 07:00:00	SPY	ETF	148.66	148.66	148.66	148.66	100000.0
2007-06-27 07:05:00	SPY	ETF	148.68	148.7	148.68	148.7	60900.0
2007-06-27 07:10:00	SPY	ETF	148.61	148.61	148.6	148.6	25900.0
2007-06-27 07:15:00	SPY	ETF	148.6	148.6	148.57	148.6	106100.0
2007-06-27 07:20:00	SPY	ETF	148.57	148.57	148.55	148.56	12500.0
2007-06-27 07:25:00	SPY	ETF	148.56	148.56	148.4	148.4	51700.0
2007-06-27 07:30:00	SPY	ETF	148.32	148.34	148.27	148.32	22500.0
2007-06-27 07:35:00	SPY	ETF	148.35	148.38	148.32	148.38	180200.0
2007-06-27 07:40:00	SPY	ETF	148.38	148.43	148.33	148.36	86400.0
2007-06-27 07:45:00	SPY	ETF	148.41	148.41	148.38	148.38	43100.0
2007-06-27 07:50:00	SPY	ETF	148.37	148.4	148.37	148.4	7100.0
2007-06-27 07:55:00	SPY	ETF	148.39	148.4	148.27	148.27	466400.0
2007-06-27 08:00:00	SPY	ETF	148.28	148.3	148.25	148.3	364500.0
2007-06-27 08:05:00	SPY	ETF	148.28	148.28	148.21	148.27	213000.0
2007-06-27 08:10:00	SPY	ETF	148.24	148.28	148.21	148.24	321800.0
2007-06-27 08:15:00	SPY	ETF	148.22	148.24	148.18	148.21	543800.0
2007-06-27 08:20:00	SPY	ETF	148.19	148.19	148.11	148.12	206500.0
2007-06-27 08:25:00	SPY	ETF	148.14	148.26	148.12	148.26	126500.0
2007-06-27 08:30:00	SPY	ETF	148.26	148.26	147.81	148.1	2078200.0
2007-06-27 08:35:00	SPY	ETF	148.1	148.29	147.98	148.0	13518100.0
2007-06-27 08:40:00	SPY	ETF	148.0	148.1	147.96	148.04	377700.0
2007-06-27 08:45:00	SPY	ETF	148.04	148.19	148.04	148.12	271200.0
2007-06-27 08:50:00	SPY	ETF	148.12	148.23	148.12	148.14	311200.0
2007-06-27 08:55:00	SPY	ETF	148.14	148.16	148.03	148.06	127700.0
2007-06-27 09:00:00	SPY	ETF	148.09	148.1	148.03	148.03	131800.0
2007-06-27 09:05:00	SPY	ETF	148.01	148.1	147.97	147.98	485986.0
2007-06-27 09:10:00	SPY	ETF	147.97	148.01	147.89	147.99	784600.0
2007-06-27 09:15:00	SPY	ETF	147.98	148.06	147.94	148.06	657300.0
2007-06-27 09:20:00	SPY	ETF	148.05	148.16	148.04	148.09	559200.0
2007-06-27 09:25:00	SPY	ETF	148.1	148.26	148.1	148.24	370500.0
2007-06-27 09:30:00	SPY	ETF	148.24	148.36	148.06	148.17	6629200.0
2007-06-27 09:35:00	SPY	ETF	148.175	148.57	148.17	148.54	8039208.0
2007-06-27 09:40:00	SPY	ETF	148.54	148.55	148.37	148.4	4316908.0
2007-06-27 09:45:00	SPY	ETF	148.39	148.5	148.27	148.44	3675040.0
2007-06-27 09:50:00	SPY	ETF	148.44	148.84	148.4	148.75	4726996.0
2007-06-27 09:55:00	SPY	ETF	148.75	148.8	148.56	148.59	3317447.0
2007-06-27 10:00:00	SPY	ETF	148.6	148.6	148.38	148.5	3545300.0
2007-06-27 10:05:00	SPY	ETF	148.5	148.77	148.49	148.69	2446222.0
2007-06-27 10:10:00	SPY	ETF	148.69	148.72	148.46	148.53	1874214.0
2007-06-27 10:15:00	SPY	ETF	148.53	148.69	148.5	148.52	1945300.0
2007-06-27 10:20:00	SPY	ETF	148.53	148.7	148.47	148.62	2407226.0
2007-06-27 10:25:00	SPY	ETF	148.63	148.8	148.57	148.76	5846599.0
2007-06-27 10:30:00	SPY	ETF	148.77	149.17	148.72	149.15	7661157.0

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

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