PREVIEW / etf_5min / 2009-10-29

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-10-29.parquet
  size:    789 KB
  rows:    31,888

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-10-29 04:15:00	SPY	ETF	104.7	104.8	104.68	104.75	7800.0
2009-10-29 04:20:00	SPY	ETF	104.82	104.82	104.82	104.82	100.0
2009-10-29 04:55:00	SPY	ETF	104.73	104.75	104.73	104.75	1000.0
2009-10-29 05:00:00	SPY	ETF	104.72	104.72	104.72	104.72	100.0
2009-10-29 05:05:00	SPY	ETF	104.87	104.88	104.87	104.88	400.0
2009-10-29 05:10:00	SPY	ETF	104.85	104.85	104.81	104.81	1300.0
2009-10-29 05:15:00	SPY	ETF	104.7	104.7	104.7	104.7	300.0
2009-10-29 05:20:00	SPY	ETF	104.74	104.79	104.74	104.79	300.0
2009-10-29 05:25:00	SPY	ETF	104.84	104.84	104.84	104.84	300.0
2009-10-29 05:30:00	SPY	ETF	104.85	104.85	104.85	104.85	350.0
2009-10-29 05:40:00	SPY	ETF	104.78	104.78	104.78	104.78	100.0
2009-10-29 05:45:00	SPY	ETF	104.78	104.78	104.78	104.78	100.0
2009-10-29 05:50:00	SPY	ETF	104.8	104.8	104.8	104.8	100.0
2009-10-29 05:55:00	SPY	ETF	104.8	104.8	104.8	104.8	200.0
2009-10-29 06:10:00	SPY	ETF	104.78	104.78	104.78	104.78	700.0
2009-10-29 06:15:00	SPY	ETF	104.79	104.79	104.76	104.76	1000.0
2009-10-29 06:25:00	SPY	ETF	104.72	104.72	104.7	104.7	1100.0
2009-10-29 06:35:00	SPY	ETF	104.78	104.78	104.74	104.74	1100.0
2009-10-29 06:40:00	SPY	ETF	104.67	104.75	104.67	104.75	800.0
2009-10-29 06:45:00	SPY	ETF	104.76	104.76	104.74	104.74	5000.0
2009-10-29 06:55:00	SPY	ETF	104.72	104.8	104.72	104.79	7800.0
2009-10-29 07:00:00	SPY	ETF	104.87	104.9	104.87	104.88	51200.0
2009-10-29 07:05:00	SPY	ETF	104.79	104.86	104.76	104.85	17800.0
2009-10-29 07:10:00	SPY	ETF	104.87	104.87	104.83	104.83	45150.0
2009-10-29 07:15:00	SPY	ETF	104.85	104.86	104.78	104.82	8100.0
2009-10-29 07:20:00	SPY	ETF	104.78	104.83	104.78	104.83	1800.0
2009-10-29 07:25:00	SPY	ETF	104.83	104.85	104.78	104.81	7100.0
2009-10-29 07:30:00	SPY	ETF	104.81	104.84	104.78	104.82	26494.0
2009-10-29 07:35:00	SPY	ETF	104.75	104.76	104.7	104.71	24498.0
2009-10-29 07:40:00	SPY	ETF	104.72	104.79	104.7	104.7	114875.0
2009-10-29 07:45:00	SPY	ETF	104.74	104.74	104.67	104.69	41771.0
2009-10-29 07:50:00	SPY	ETF	104.67	104.7	104.63	104.7	30899.0
2009-10-29 07:55:00	SPY	ETF	104.7	104.7	104.6	104.65	91195.0
2009-10-29 08:00:00	SPY	ETF	104.66	104.84	104.55	104.56	389425.0
2009-10-29 08:05:00	SPY	ETF	104.56	104.68	104.55	104.56	287093.0
2009-10-29 08:10:00	SPY	ETF	104.56	104.67	104.56	104.63	177675.0
2009-10-29 08:15:00	SPY	ETF	104.64	104.69	104.5	104.52	267787.0
2009-10-29 08:20:00	SPY	ETF	104.52	104.56	104.47	104.53	205713.0
2009-10-29 08:25:00	SPY	ETF	104.53	104.77	104.5	104.76	149440.0
2009-10-29 08:30:00	SPY	ETF	104.7	105.32	104.67	105.17	3701865.0
2009-10-29 08:35:00	SPY	ETF	105.17	105.19	105.02	105.07	948170.0
2009-10-29 08:40:00	SPY	ETF	105.07	105.22	105.02	105.18	340139.0
2009-10-29 08:45:00	SPY	ETF	105.19	105.35	105.15	105.25	790868.0
2009-10-29 08:50:00	SPY	ETF	105.25	105.39	105.2	105.37	443227.0
2009-10-29 08:55:00	SPY	ETF	105.36	105.44	105.28	105.43	989973.0
2009-10-29 09:00:00	SPY	ETF	105.43	105.46	105.34	105.39	680470.0
2009-10-29 09:05:00	SPY	ETF	105.4	105.41	105.25	105.25	323047.0
2009-10-29 09:10:00	SPY	ETF	105.25	105.27	105.21	105.27	183577.0
2009-10-29 09:15:00	SPY	ETF	105.27	105.32	105.23	105.23	165751.0
2009-10-29 09:20:00	SPY	ETF	105.23	105.29	105.19	105.2	499219.0

> showing 50 of 31,888 rows — these rows as CSV

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