PREVIEW / etf_5min / 2009-06-15

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-06-15.parquet
  size:    692 KB
  rows:    30,374

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-06-15 05:00:00	SPY	ETF	93.78	93.78	93.78	93.78	2500.0
2009-06-15 05:35:00	SPY	ETF	93.68	93.68	93.68	93.68	1000.0
2009-06-15 05:40:00	SPY	ETF	93.82	93.82	93.82	93.82	5000.0
2009-06-15 05:45:00	SPY	ETF	93.83	93.85	93.83	93.85	5000.0
2009-06-15 06:00:00	SPY	ETF	93.84	93.84	93.84	93.84	2000.0
2009-06-15 06:05:00	SPY	ETF	93.87	93.87	93.87	93.87	2000.0
2009-06-15 06:20:00	SPY	ETF	93.95	93.95	93.95	93.95	2000.0
2009-06-15 06:25:00	SPY	ETF	94.02	94.02	93.89	93.89	2000.0
2009-06-15 06:45:00	SPY	ETF	93.99	94.0	93.99	94.0	20000.0
2009-06-15 06:55:00	SPY	ETF	93.89	93.89	93.87	93.87	1050.0
2009-06-15 07:00:00	SPY	ETF	93.84	93.85	93.73	93.78	85332.0
2009-06-15 07:05:00	SPY	ETF	93.78	93.81	93.75	93.75	41395.0
2009-06-15 07:10:00	SPY	ETF	93.78	93.94	93.78	93.86	106150.0
2009-06-15 07:15:00	SPY	ETF	93.88	93.92	93.88	93.92	6750.0
2009-06-15 07:20:00	SPY	ETF	93.96	93.96	93.89	93.89	46852.0
2009-06-15 07:25:00	SPY	ETF	93.89	93.89	93.76	93.77	14823.0
2009-06-15 07:30:00	SPY	ETF	93.81	93.94	93.8	93.93	42742.0
2009-06-15 07:35:00	SPY	ETF	93.94	93.94	93.9	93.92	102314.0
2009-06-15 07:40:00	SPY	ETF	93.92	93.92	93.87	93.87	88309.0
2009-06-15 07:45:00	SPY	ETF	93.87	93.9	93.86	93.87	171597.0
2009-06-15 07:50:00	SPY	ETF	93.87	93.93	93.87	93.92	253558.0
2009-06-15 07:55:00	SPY	ETF	93.93	93.93	93.81	93.83	231715.0
2009-06-15 08:00:00	SPY	ETF	93.84	94.3	93.79	93.8	261375.0
2009-06-15 08:05:00	SPY	ETF	93.8	93.82	93.76	93.8	752567.0
2009-06-15 08:10:00	SPY	ETF	93.8	94.5129	93.79	93.87	164492.0
2009-06-15 08:15:00	SPY	ETF	93.87	93.93	93.86	93.93	77446.0
2009-06-15 08:20:00	SPY	ETF	93.93	94.04	93.88	94.02	212297.0
2009-06-15 08:25:00	SPY	ETF	94.02	94.07	93.89	93.89	277052.0
2009-06-15 08:30:00	SPY	ETF	93.92	93.95	93.66	93.81	572768.0
2009-06-15 08:35:00	SPY	ETF	93.82	93.95	93.81	93.94	162713.0
2009-06-15 08:40:00	SPY	ETF	93.94	93.98	93.91	93.97	71174.0
2009-06-15 08:45:00	SPY	ETF	93.97	94.02	93.91	93.92	178609.0
2009-06-15 08:50:00	SPY	ETF	93.93	94.0	93.91	93.96	284439.0
2009-06-15 08:55:00	SPY	ETF	93.97	93.98	93.92	93.96	117290.0
2009-06-15 09:00:00	SPY	ETF	93.96	93.99	93.87	93.93	1219915.0
2009-06-15 09:05:00	SPY	ETF	93.93	93.93	93.81	93.81	147923.0
2009-06-15 09:10:00	SPY	ETF	93.82	93.88	93.81	93.86	67464.0
2009-06-15 09:15:00	SPY	ETF	93.85	93.85	93.77	93.82	374373.0
2009-06-15 09:20:00	SPY	ETF	93.82	93.89	93.81	93.87	64437.0
2009-06-15 09:25:00	SPY	ETF	93.86	93.98	93.83	93.96	894550.0
2009-06-15 09:30:00	SPY	ETF	93.96	94.02	93.65	93.6599	6379368.0
2009-06-15 09:35:00	SPY	ETF	93.65	93.81	93.6	93.77	5601250.0
2009-06-15 09:40:00	SPY	ETF	93.76	93.77	93.58	93.61	3141901.0
2009-06-15 09:45:00	SPY	ETF	93.61	93.94	93.2	93.32	7721488.0
2009-06-15 09:50:00	SPY	ETF	93.3101	93.46	93.25	93.44	5550319.0
2009-06-15 09:55:00	SPY	ETF	93.43	93.65	93.36	93.59	5409210.0
2009-06-15 10:00:00	SPY	ETF	93.59	93.63	93.47	93.47	4128840.0
2009-06-15 10:05:00	SPY	ETF	93.46	93.57	93.43	93.54	1499146.0
2009-06-15 10:10:00	SPY	ETF	93.53	93.59	93.44	93.44	2158360.0
2009-06-15 10:15:00	SPY	ETF	93.44	93.45	93.32	93.44	2974735.0

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

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