PREVIEW / etf_5min / 2009-07-15

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-15.parquet
  size:    738 KB
  rows:    30,250

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-07-15 04:20:00	SPY	ETF	91.39	91.39	91.39	91.39	300.0
2009-07-15 04:30:00	SPY	ETF	91.5	91.5	91.5	91.5	100.0
2009-07-15 04:40:00	SPY	ETF	91.5	91.5	91.5	91.5	500.0
2009-07-15 04:55:00	SPY	ETF	91.59	91.59	91.59	91.59	300.0
2009-07-15 05:10:00	SPY	ETF	91.59	91.6	91.59	91.6	2100.0
2009-07-15 05:45:00	SPY	ETF	91.65	91.65	91.65	91.65	374.0
2009-07-15 05:50:00	SPY	ETF	91.62	91.67	91.62	91.67	537.0
2009-07-15 06:00:00	SPY	ETF	91.67	91.67	91.67	91.67	2500.0
2009-07-15 06:05:00	SPY	ETF	91.69	91.7	91.69	91.7	300.0
2009-07-15 06:15:00	SPY	ETF	91.65	91.66	91.65	91.66	15000.0
2009-07-15 06:25:00	SPY	ETF	91.67	91.7	91.67	91.7	549.0
2009-07-15 06:30:00	SPY	ETF	91.69	91.69	91.69	91.69	100.0
2009-07-15 06:35:00	SPY	ETF	91.67	91.7	91.67	91.7	1500.0
2009-07-15 06:40:00	SPY	ETF	91.7	91.7	91.7	91.7	1000.0
2009-07-15 06:45:00	SPY	ETF	91.73	91.78	91.73	91.78	2800.0
2009-07-15 06:50:00	SPY	ETF	91.8	91.8	91.78	91.78	800.0
2009-07-15 06:55:00	SPY	ETF	91.73	91.73	91.67	91.67	700.0
2009-07-15 07:00:00	SPY	ETF	91.68	91.69	91.64	91.64	22756.0
2009-07-15 07:05:00	SPY	ETF	91.65	91.71	91.65	91.69	26100.0
2009-07-15 07:10:00	SPY	ETF	91.72	91.75	91.7	91.7	20600.0
2009-07-15 07:15:00	SPY	ETF	91.72	91.72	91.57	91.65	25496.0
2009-07-15 07:20:00	SPY	ETF	91.64	91.65	91.62	91.65	63000.0
2009-07-15 07:25:00	SPY	ETF	91.64	91.65	91.54	91.55	23272.0
2009-07-15 07:30:00	SPY	ETF	91.59	91.6	91.52	91.55	30750.0
2009-07-15 07:35:00	SPY	ETF	91.55	91.55	91.44	91.44	55240.0
2009-07-15 07:40:00	SPY	ETF	91.47	91.5	91.45	91.47	222944.0
2009-07-15 07:45:00	SPY	ETF	91.49	91.58	91.46	91.46	47320.0
2009-07-15 07:50:00	SPY	ETF	91.46	91.53	91.43	91.53	45250.0
2009-07-15 07:55:00	SPY	ETF	91.53	91.63	91.53	91.63	41025.0
2009-07-15 08:00:00	SPY	ETF	91.63	91.95	91.61	91.77	320992.0
2009-07-15 08:05:00	SPY	ETF	91.77	91.77	91.68	91.69	196900.0
2009-07-15 08:10:00	SPY	ETF	91.69	91.72	91.63	91.63	123771.0
2009-07-15 08:15:00	SPY	ETF	91.63	91.7	91.63	91.7	132877.0
2009-07-15 08:20:00	SPY	ETF	91.7	91.72	91.68	91.72	44529.0
2009-07-15 08:25:00	SPY	ETF	91.72	91.72	91.6	91.68	295744.0
2009-07-15 08:30:00	SPY	ETF	91.7	91.9	91.66	91.72	848943.0
2009-07-15 08:35:00	SPY	ETF	91.73	91.75	91.69	91.72	79726.0
2009-07-15 08:40:00	SPY	ETF	91.72	91.73	91.65	91.68	74917.0
2009-07-15 08:45:00	SPY	ETF	91.68	91.73	91.68	91.73	41534.0
2009-07-15 08:50:00	SPY	ETF	91.73	91.74	90.63	91.71	146441.0
2009-07-15 08:55:00	SPY	ETF	91.7	91.75	91.68	91.74	197091.0
2009-07-15 09:00:00	SPY	ETF	91.74	91.83	91.73	91.82	250004.0
2009-07-15 09:05:00	SPY	ETF	91.82	91.9	91.8	91.82	230354.0
2009-07-15 09:10:00	SPY	ETF	91.82	91.86	91.76	91.86	267092.0
2009-07-15 09:15:00	SPY	ETF	91.86	91.87	91.79	91.81	284327.0
2009-07-15 09:20:00	SPY	ETF	91.81	91.84	91.77	91.82	340855.0
2009-07-15 09:25:00	SPY	ETF	91.82	91.82	91.78	91.81	548827.0
2009-07-15 09:30:00	SPY	ETF	91.81	91.87	91.71	91.84	4526986.0
2009-07-15 09:35:00	SPY	ETF	91.84	91.87	91.68	91.87	2863615.0
2009-07-15 09:40:00	SPY	ETF	91.87	92.11	91.86	92.11	5301621.0

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

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