PREVIEW / etf_5min / 2009-10-23

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-10-23.parquet
  size:    752 KB
  rows:    30,547

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-23 04:15:00	SPY	ETF	109.81	109.81	109.81	109.81	900.0
2009-10-23 04:30:00	SPY	ETF	109.59	109.59	109.59	109.59	400.0
2009-10-23 04:35:00	SPY	ETF	109.56	109.56	109.53	109.53	500.0
2009-10-23 04:40:00	SPY	ETF	109.63	109.68	109.63	109.68	220.0
2009-10-23 05:00:00	SPY	ETF	109.49	109.49	109.43	109.43	200.0
2009-10-23 05:50:00	SPY	ETF	109.61	109.61	109.61	109.61	200.0
2009-10-23 05:55:00	SPY	ETF	109.61	109.61	109.61	109.61	100.0
2009-10-23 06:00:00	SPY	ETF	109.58	109.58	109.58	109.58	200.0
2009-10-23 06:10:00	SPY	ETF	109.54	109.54	109.54	109.54	1000.0
2009-10-23 06:25:00	SPY	ETF	109.44	109.44	109.44	109.44	1500.0
2009-10-23 06:35:00	SPY	ETF	109.48	109.48	109.45	109.45	7500.0
2009-10-23 06:40:00	SPY	ETF	109.49	109.49	109.49	109.49	100.0
2009-10-23 06:55:00	SPY	ETF	109.54	109.54	109.54	109.54	200.0
2009-10-23 07:00:00	SPY	ETF	109.5	109.54	109.45	109.54	17750.0
2009-10-23 07:05:00	SPY	ETF	109.57	109.65	109.57	109.65	1100.0
2009-10-23 07:10:00	SPY	ETF	109.65	109.69	109.63	109.69	37313.0
2009-10-23 07:15:00	SPY	ETF	109.64	109.65	109.62	109.62	18424.0
2009-10-23 07:20:00	SPY	ETF	109.62	109.64	109.61	109.64	10399.0
2009-10-23 07:25:00	SPY	ETF	109.65	109.72	109.65	109.71	26350.0
2009-10-23 07:30:00	SPY	ETF	109.74	109.78	109.68	109.72	90938.0
2009-10-23 07:35:00	SPY	ETF	109.69	109.69	109.61	109.65	6200.0
2009-10-23 07:40:00	SPY	ETF	109.67	109.7	109.67	109.7	11500.0
2009-10-23 07:45:00	SPY	ETF	109.7	109.7	109.67	109.67	22700.0
2009-10-23 07:50:00	SPY	ETF	109.66	109.68	109.66	109.68	3100.0
2009-10-23 07:55:00	SPY	ETF	109.72	109.72	109.68	109.68	18999.0
2009-10-23 08:00:00	SPY	ETF	109.66	109.69	109.66	109.67	16364.0
2009-10-23 08:05:00	SPY	ETF	109.67	109.7	109.58	109.61	51009.0
2009-10-23 08:10:00	SPY	ETF	109.6	109.7	109.6	109.66	53505.0
2009-10-23 08:15:00	SPY	ETF	109.66	109.68	109.64	109.67	26300.0
2009-10-23 08:20:00	SPY	ETF	109.65	109.7	109.65	109.65	58399.0
2009-10-23 08:25:00	SPY	ETF	109.68	109.69	109.63	109.68	71781.0
2009-10-23 08:30:00	SPY	ETF	109.66	109.91	109.66	109.84	1482622.0
2009-10-23 08:35:00	SPY	ETF	109.83	109.93	109.76	109.91	373570.0
2009-10-23 08:40:00	SPY	ETF	109.9	109.95	109.83	109.87	296692.0
2009-10-23 08:45:00	SPY	ETF	109.86	109.95	109.84	109.89	389332.0
2009-10-23 08:50:00	SPY	ETF	109.88	109.93	109.86	109.9	248568.0
2009-10-23 08:55:00	SPY	ETF	109.89	109.94	109.88	109.9	214329.0
2009-10-23 09:00:00	SPY	ETF	109.91	109.97	109.91	109.96	155920.0
2009-10-23 09:05:00	SPY	ETF	109.95	109.98	109.87	109.93	231784.0
2009-10-23 09:10:00	SPY	ETF	109.92	109.93	109.71	109.74	631543.0
2009-10-23 09:15:00	SPY	ETF	109.75	109.82	109.75	109.8	319535.0
2009-10-23 09:20:00	SPY	ETF	109.82	109.87	109.34	109.84	361607.0
2009-10-23 09:25:00	SPY	ETF	109.83	109.85	109.67	109.68	484514.0
2009-10-23 09:30:00	SPY	ETF	109.69	109.76	109.59	109.625	4521396.0
2009-10-23 09:35:00	SPY	ETF	109.63	109.69	109.31	109.54	7612529.0
2009-10-23 09:40:00	SPY	ETF	109.54	109.56	109.3	109.361	4811429.0
2009-10-23 09:45:00	SPY	ETF	109.36	109.6788	109.19	109.38	3886978.0
2009-10-23 09:50:00	SPY	ETF	109.38	109.53	109.32	109.44	3071344.0
2009-10-23 09:55:00	SPY	ETF	109.44	109.46	109.22	109.41	2800584.0
2009-10-23 10:00:00	SPY	ETF	109.41	109.73	109.03	109.03	10646764.0

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

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