PREVIEW / etf_5min / 2009-03-25

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-03-25.parquet
  size:    709 KB
  rows:    29,291

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-03-25 04:15:00	SPY	ETF	81.0	81.0	81.0	81.0	200.0
2009-03-25 04:25:00	SPY	ETF	81.09	81.09	81.09	81.09	200.0
2009-03-25 04:40:00	SPY	ETF	81.2	81.22	81.2	81.22	200.0
2009-03-25 04:50:00	SPY	ETF	81.24	81.24	81.24	81.24	400.0
2009-03-25 04:55:00	SPY	ETF	81.2	81.2	81.2	81.2	200.0
2009-03-25 05:05:00	SPY	ETF	81.29	81.29	81.29	81.29	150.0
2009-03-25 05:10:00	SPY	ETF	81.3	81.33	81.3	81.33	300.0
2009-03-25 05:25:00	SPY	ETF	81.28	81.28	81.28	81.28	100.0
2009-03-25 05:30:00	SPY	ETF	81.29	81.29	81.29	81.29	100.0
2009-03-25 05:40:00	SPY	ETF	81.29	81.29	81.29	81.29	2000.0
2009-03-25 05:50:00	SPY	ETF	81.12	81.12	81.12	81.12	100.0
2009-03-25 05:55:00	SPY	ETF	81.08	81.08	81.08	81.08	2000.0
2009-03-25 06:15:00	SPY	ETF	81.11	81.11	81.03	81.03	1300.0
2009-03-25 06:20:00	SPY	ETF	81.06	81.06	81.06	81.06	100.0
2009-03-25 06:30:00	SPY	ETF	81.04	81.04	81.04	81.04	650.0
2009-03-25 06:35:00	SPY	ETF	81.07	81.07	81.07	81.07	100.0
2009-03-25 06:45:00	SPY	ETF	81.05	81.06	81.05	81.05	27500.0
2009-03-25 06:50:00	SPY	ETF	81.09	81.09	81.0	81.0	600.0
2009-03-25 06:55:00	SPY	ETF	80.92	80.96	80.92	80.96	700.0
2009-03-25 07:00:00	SPY	ETF	80.93	80.97	80.81	80.81	23030.0
2009-03-25 07:05:00	SPY	ETF	80.83	80.91	80.83	80.85	71200.0
2009-03-25 07:10:00	SPY	ETF	80.85	80.85	80.7	80.7	81450.0
2009-03-25 07:15:00	SPY	ETF	80.74	80.77	80.66	80.66	28898.0
2009-03-25 07:20:00	SPY	ETF	80.69	80.82	80.69	80.82	19600.0
2009-03-25 07:25:00	SPY	ETF	80.83	80.85	80.81	80.83	2250.0
2009-03-25 07:30:00	SPY	ETF	80.87	80.92	80.86	80.87	15500.0
2009-03-25 07:35:00	SPY	ETF	80.84	80.84	80.78	80.78	8208.0
2009-03-25 07:40:00	SPY	ETF	80.81	80.84	80.79	80.84	50738.0
2009-03-25 07:45:00	SPY	ETF	80.85	80.85	80.82	80.83	6156.0
2009-03-25 07:50:00	SPY	ETF	80.81	80.88	80.79	80.84	11201.0
2009-03-25 07:55:00	SPY	ETF	80.85	80.93	80.85	80.93	65750.0
2009-03-25 08:00:00	SPY	ETF	80.93	81.26	80.9	80.98	378180.0
2009-03-25 08:05:00	SPY	ETF	80.98	81.01	80.94	80.96	269400.0
2009-03-25 08:10:00	SPY	ETF	80.82	80.96	80.81	80.93	190402.0
2009-03-25 08:15:00	SPY	ETF	80.91	80.93	80.79	80.87	97991.0
2009-03-25 08:20:00	SPY	ETF	80.87	80.96	80.5959	80.9	2085742.0
2009-03-25 08:25:00	SPY	ETF	80.89	80.93	80.86	80.93	230340.0
2009-03-25 08:30:00	SPY	ETF	80.95	81.28	80.93	81.13	2569860.0
2009-03-25 08:35:00	SPY	ETF	81.14	81.15	80.88	81.02	410393.0
2009-03-25 08:40:00	SPY	ETF	81.02	81.1	80.92	80.92	507005.0
2009-03-25 08:45:00	SPY	ETF	80.92	81.14	80.6	81.14	689694.0
2009-03-25 08:50:00	SPY	ETF	81.14	81.2	81.02	81.02	369477.0
2009-03-25 08:55:00	SPY	ETF	81.03	81.16	81.0	81.02	174149.0
2009-03-25 09:00:00	SPY	ETF	81.01	81.05	80.98	81.05	92564.0
2009-03-25 09:05:00	SPY	ETF	81.06	81.18	81.04	81.15	257265.0
2009-03-25 09:10:00	SPY	ETF	81.15	81.29	81.12	81.26	509769.0
2009-03-25 09:15:00	SPY	ETF	81.28	81.29	81.24	81.26	142722.0
2009-03-25 09:20:00	SPY	ETF	81.27	81.35	81.26	81.27	295117.0
2009-03-25 09:25:00	SPY	ETF	81.26	81.29	81.19	81.22	390279.0
2009-03-25 09:30:00	SPY	ETF	81.23	81.57	81.13	81.5362	7584884.0

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

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