PREVIEW / etf_5min / 2009-10-16

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-10-16.parquet
  size:    724 KB
  rows:    30,705

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-16 04:15:00	SPY	ETF	109.72	109.78	109.72	109.75	2100.0
2009-10-16 04:25:00	SPY	ETF	109.79	109.79	109.79	109.79	300.0
2009-10-16 04:50:00	SPY	ETF	109.63	109.63	109.63	109.63	100.0
2009-10-16 05:05:00	SPY	ETF	109.64	109.64	109.64	109.64	150.0
2009-10-16 06:10:00	SPY	ETF	109.67	109.67	109.67	109.67	100.0
2009-10-16 06:30:00	SPY	ETF	109.63	109.63	109.51	109.53	650.0
2009-10-16 06:35:00	SPY	ETF	109.55	109.55	109.4	109.4	1303.0
2009-10-16 06:40:00	SPY	ETF	109.41	109.41	109.41	109.41	110.0
2009-10-16 06:45:00	SPY	ETF	109.36	109.36	109.3	109.34	1250.0
2009-10-16 06:50:00	SPY	ETF	109.36	109.36	109.36	109.36	1850.0
2009-10-16 06:55:00	SPY	ETF	109.35	109.35	109.24	109.24	900.0
2009-10-16 07:00:00	SPY	ETF	109.16	109.19	108.97	109.07	151714.0
2009-10-16 07:05:00	SPY	ETF	109.06	109.1	108.99	109.09	110000.0
2009-10-16 07:10:00	SPY	ETF	109.09	109.17	109.06	109.06	18002.0
2009-10-16 07:15:00	SPY	ETF	109.13	109.17	109.09	109.13	93022.0
2009-10-16 07:20:00	SPY	ETF	109.13	109.13	109.0	109.05	40101.0
2009-10-16 07:25:00	SPY	ETF	109.03	109.05	108.98	108.99	24854.0
2009-10-16 07:30:00	SPY	ETF	109.01	109.09	109.01	109.04	31414.0
2009-10-16 07:35:00	SPY	ETF	109.06	109.08	109.05	109.06	2806.0
2009-10-16 07:40:00	SPY	ETF	109.08	109.09	109.0	109.0	158702.0
2009-10-16 07:45:00	SPY	ETF	108.98	108.98	108.82	108.9	76053.0
2009-10-16 07:50:00	SPY	ETF	108.94	108.94	108.82	108.91	102414.0
2009-10-16 07:55:00	SPY	ETF	108.92	109.01	108.9	109.01	56599.0
2009-10-16 08:00:00	SPY	ETF	109.02	109.5	108.98	109.0	97981.0
2009-10-16 08:05:00	SPY	ETF	109.0	109.01	108.9	108.91	170942.0
2009-10-16 08:10:00	SPY	ETF	108.9	108.91	108.81	108.83	231187.0
2009-10-16 08:15:00	SPY	ETF	108.84	108.88	108.76	108.76	108327.0
2009-10-16 08:20:00	SPY	ETF	108.78	108.78	108.53	108.63	981664.0
2009-10-16 08:25:00	SPY	ETF	108.64	108.75	108.62	108.66	437771.0
2009-10-16 08:30:00	SPY	ETF	108.66	108.75	108.63	108.74	155674.0
2009-10-16 08:35:00	SPY	ETF	108.74	108.76	108.69	108.74	155993.0
2009-10-16 08:40:00	SPY	ETF	108.74	108.75	108.64	108.64	170251.0
2009-10-16 08:45:00	SPY	ETF	108.65	108.71	108.65	108.67	438651.0
2009-10-16 08:50:00	SPY	ETF	108.68	108.71	108.65	108.65	144039.0
2009-10-16 08:55:00	SPY	ETF	108.65	108.75	108.65	108.74	150503.0
2009-10-16 09:00:00	SPY	ETF	108.74	108.9	108.74	108.86	221066.0
2009-10-16 09:05:00	SPY	ETF	108.86	108.9	108.8	108.81	241438.0
2009-10-16 09:10:00	SPY	ETF	108.81	108.88	108.78	108.84	139548.0
2009-10-16 09:15:00	SPY	ETF	108.84	108.99	108.82	108.89	434052.0
2009-10-16 09:20:00	SPY	ETF	108.91	109.65	108.77	108.77	225939.0
2009-10-16 09:25:00	SPY	ETF	108.77	108.8	108.73	108.8	312842.0
2009-10-16 09:30:00	SPY	ETF	108.8	108.89	108.63	108.75	5780019.0
2009-10-16 09:35:00	SPY	ETF	108.75	108.93	108.71	108.92	3692365.0
2009-10-16 09:40:00	SPY	ETF	108.92	109.0	108.81	108.87	6340343.0
2009-10-16 09:45:00	SPY	ETF	108.8601	109.01	108.82	108.97	2466620.0
2009-10-16 09:50:00	SPY	ETF	108.98	109.06	108.8	108.8494	2972889.0
2009-10-16 09:55:00	SPY	ETF	108.84	108.97	108.57	108.64	8972728.0
2009-10-16 10:00:00	SPY	ETF	108.64	108.64	108.33	108.37	6239726.0
2009-10-16 10:05:00	SPY	ETF	108.365	108.48	108.29	108.34	3049190.0
2009-10-16 10:10:00	SPY	ETF	108.34	108.43	108.28	108.37	3229992.0

> showing 50 of 30,705 rows — these rows as CSV

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