PREVIEW / etf_5min / 2009-04-09

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-04-09.parquet
  size:    682 KB
  rows:    29,181

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
2009-04-09 04:15:00	SPY	ETF	83.22	83.22	83.14	83.14	1500.0
2009-04-09 05:10:00	SPY	ETF	83.33	83.33	83.33	83.33	100.0
2009-04-09 05:15:00	SPY	ETF	83.33	83.33	83.3	83.31	400.0
2009-04-09 05:20:00	SPY	ETF	83.3	83.3	83.3	83.3	100.0
2009-04-09 05:25:00	SPY	ETF	83.35	83.35	83.31	83.31	25100.0
2009-04-09 05:35:00	SPY	ETF	83.33	83.33	83.33	83.33	500.0
2009-04-09 05:40:00	SPY	ETF	83.3	83.38	83.3	83.38	1000.0
2009-04-09 05:45:00	SPY	ETF	83.46	83.5	83.46	83.5	650.0
2009-04-09 05:50:00	SPY	ETF	83.5	83.5	83.5	83.5	19900.0
2009-04-09 06:00:00	SPY	ETF	83.45	83.45	83.39	83.39	500.0
2009-04-09 06:05:00	SPY	ETF	83.32	83.32	83.32	83.32	100.0
2009-04-09 06:10:00	SPY	ETF	83.37	83.37	83.37	83.37	5500.0
2009-04-09 06:15:00	SPY	ETF	83.37	83.37	83.3	83.3	9600.0
2009-04-09 06:25:00	SPY	ETF	83.36	83.36	83.36	83.36	100.0
2009-04-09 06:30:00	SPY	ETF	83.35	83.35	83.28	83.3	1100.0
2009-04-09 06:35:00	SPY	ETF	83.23	83.26	83.23	83.26	5000.0
2009-04-09 06:40:00	SPY	ETF	83.29	83.29	83.29	83.29	100.0
2009-04-09 06:45:00	SPY	ETF	83.26	83.3	83.26	83.3	200.0
2009-04-09 06:55:00	SPY	ETF	83.27	83.28	83.27	83.27	3900.0
2009-04-09 07:00:00	SPY	ETF	83.26	83.31	83.24	83.26	9000.0
2009-04-09 07:05:00	SPY	ETF	83.27	83.31	83.22	83.24	15109.0
2009-04-09 07:10:00	SPY	ETF	83.24	83.24	83.12	83.12	54350.0
2009-04-09 07:15:00	SPY	ETF	83.09	83.14	83.08	83.14	21250.0
2009-04-09 07:20:00	SPY	ETF	83.18	83.24	83.18	83.22	61800.0
2009-04-09 07:25:00	SPY	ETF	83.24	83.25	83.2	83.2	75950.0
2009-04-09 07:30:00	SPY	ETF	83.16	83.22	83.15	83.21	75000.0
2009-04-09 07:35:00	SPY	ETF	83.22	83.22	83.21	83.22	26090.0
2009-04-09 07:40:00	SPY	ETF	83.21	83.21	83.0	83.02	59500.0
2009-04-09 07:45:00	SPY	ETF	83.03	83.07	83.01	83.05	45200.0
2009-04-09 07:50:00	SPY	ETF	83.05	83.16	83.02	83.15	72900.0
2009-04-09 07:55:00	SPY	ETF	83.17	83.23	83.06	83.1	37689.0
2009-04-09 08:00:00	SPY	ETF	83.09	84.38	83.09	84.37	3048846.0
2009-04-09 08:05:00	SPY	ETF	84.37	84.4	83.94	84.16	1358658.0
2009-04-09 08:10:00	SPY	ETF	84.2	84.25	84.04	84.07	763922.0
2009-04-09 08:15:00	SPY	ETF	84.06	84.21	84.01	84.04	583256.0
2009-04-09 08:20:00	SPY	ETF	84.04	84.25	84.04	84.15	371016.0
2009-04-09 08:25:00	SPY	ETF	84.16	84.3	84.16	84.3	662891.0
2009-04-09 08:30:00	SPY	ETF	84.29	84.42	84.2	84.31	1139276.0
2009-04-09 08:35:00	SPY	ETF	84.31	84.36	84.21	84.29	669249.0
2009-04-09 08:40:00	SPY	ETF	84.29	84.48	84.2	84.48	1089022.0
2009-04-09 08:45:00	SPY	ETF	84.48	84.7	84.46	84.66	814160.0
2009-04-09 08:50:00	SPY	ETF	84.65	84.8	84.64	84.73	684185.0
2009-04-09 08:55:00	SPY	ETF	84.73	84.83	84.55	84.61	640139.0
2009-04-09 09:00:00	SPY	ETF	84.61	84.63	84.54	84.54	484059.0
2009-04-09 09:05:00	SPY	ETF	84.54	84.71	84.51	84.68	390646.0
2009-04-09 09:10:00	SPY	ETF	84.69	84.73	82.49	84.67	604672.0
2009-04-09 09:15:00	SPY	ETF	84.67	84.73	84.66	84.72	156874.0
2009-04-09 09:20:00	SPY	ETF	84.71	84.75	84.55	84.61	628502.0
2009-04-09 09:25:00	SPY	ETF	84.61	84.72	84.61	84.67	522758.0
2009-04-09 09:30:00	SPY	ETF	84.67	84.73	84.4701	84.56	6007225.0

> showing 50 of 29,181 rows — these rows as CSV

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