PREVIEW / etf_5min / 2007-12-31

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-12-31.parquet
  size:    397 KB
  rows:    20,061

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-12-31 05:30:00	SPY	ETF	147.72	147.72	147.72	147.72	100.0
2007-12-31 05:55:00	SPY	ETF	147.59	147.59	147.59	147.59	2000.0
2007-12-31 06:10:00	SPY	ETF	147.65	147.65	147.65	147.65	1000.0
2007-12-31 06:25:00	SPY	ETF	147.67	147.67	147.67	147.67	1000.0
2007-12-31 06:30:00	SPY	ETF	147.62	147.62	147.62	147.62	1000.0
2007-12-31 06:45:00	SPY	ETF	147.62	147.63	147.62	147.63	1000.0
2007-12-31 06:50:00	SPY	ETF	147.62	147.62	147.62	147.62	10000.0
2007-12-31 07:00:00	SPY	ETF	147.62	147.62	147.6	147.6	4500.0
2007-12-31 07:05:00	SPY	ETF	147.61	147.65	147.61	147.65	7900.0
2007-12-31 07:10:00	SPY	ETF	147.6	147.6	147.6	147.6	1000.0
2007-12-31 07:15:00	SPY	ETF	147.62	147.62	147.59	147.62	1700.0
2007-12-31 07:20:00	SPY	ETF	147.61	147.61	147.61	147.61	400.0
2007-12-31 07:35:00	SPY	ETF	147.6	147.65	147.59	147.65	1800.0
2007-12-31 07:40:00	SPY	ETF	147.65	147.65	147.65	147.65	1000.0
2007-12-31 07:45:00	SPY	ETF	147.61	147.7	147.59	147.7	23300.0
2007-12-31 07:50:00	SPY	ETF	147.65	147.67	147.65	147.65	11000.0
2007-12-31 07:55:00	SPY	ETF	147.65	147.7	147.65	147.67	9400.0
2007-12-31 08:00:00	SPY	ETF	147.63	147.72	147.6	147.71	516200.0
2007-12-31 08:05:00	SPY	ETF	147.66	147.68	147.66	147.68	50300.0
2007-12-31 08:10:00	SPY	ETF	147.68	147.75	147.68	147.75	92100.0
2007-12-31 08:15:00	SPY	ETF	147.73	147.73	147.67	147.7	17400.0
2007-12-31 08:20:00	SPY	ETF	147.7	147.7	147.56	147.56	54300.0
2007-12-31 08:25:00	SPY	ETF	147.55	147.6	147.53	147.59	8900.0
2007-12-31 08:30:00	SPY	ETF	147.56	147.59	147.55	147.56	31500.0
2007-12-31 08:35:00	SPY	ETF	147.55	147.56	147.53	147.55	124900.0
2007-12-31 08:40:00	SPY	ETF	147.55	147.56	147.55	147.56	1100.0
2007-12-31 08:45:00	SPY	ETF	147.56	147.56	147.53	147.53	16500.0
2007-12-31 08:50:00	SPY	ETF	147.52	147.59	147.52	147.59	19300.0
2007-12-31 08:55:00	SPY	ETF	147.6	147.6	147.53	147.53	28600.0
2007-12-31 09:00:00	SPY	ETF	147.54	147.54	147.37	147.42	83500.0
2007-12-31 09:05:00	SPY	ETF	147.41	147.41	147.12	147.25	207600.0
2007-12-31 09:10:00	SPY	ETF	147.25	147.25	147.17	147.22	265700.0
2007-12-31 09:15:00	SPY	ETF	147.21	147.25	147.2	147.2	33500.0
2007-12-31 09:20:00	SPY	ETF	147.21	147.22	147.18	147.2	16900.0
2007-12-31 09:25:00	SPY	ETF	147.17	147.19	147.0	147.11	149500.0
2007-12-31 09:30:00	SPY	ETF	147.1	147.18	146.92	147.06	1756413.0
2007-12-31 09:35:00	SPY	ETF	147.05	147.12	147.02	147.03	813378.0
2007-12-31 09:40:00	SPY	ETF	147.03	147.17	146.93	147.12	1175137.0
2007-12-31 09:45:00	SPY	ETF	147.12	147.14	147.02	147.05	449714.0
2007-12-31 09:50:00	SPY	ETF	147.06	147.09	146.87	146.98	1041300.0
2007-12-31 09:55:00	SPY	ETF	146.98	147.0	146.8	146.84	1537701.0
2007-12-31 10:00:00	SPY	ETF	146.84	147.05	146.83	147.0	1591393.0
2007-12-31 10:05:00	SPY	ETF	147.0	147.13	146.95	147.05	1433574.0
2007-12-31 10:10:00	SPY	ETF	147.06	147.17	147.05	147.17	663109.0
2007-12-31 10:15:00	SPY	ETF	147.17	147.17	146.95	147.11	467918.0
2007-12-31 10:20:00	SPY	ETF	147.1	147.11	146.82	146.9	1086276.0
2007-12-31 10:25:00	SPY	ETF	146.91	146.99	146.89	146.95	377700.0
2007-12-31 10:30:00	SPY	ETF	146.95	146.97	146.91	146.94	269800.0
2007-12-31 10:35:00	SPY	ETF	146.95	146.95	146.72	146.78	1850491.0
2007-12-31 10:40:00	SPY	ETF	146.79	146.79	146.6	146.63	1376400.0

> showing 50 of 20,061 rows — these rows as CSV

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