PREVIEW / etf_5min / 2009-10-20

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-10-20.parquet
  size:    747 KB
  rows:    30,786

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-20 04:15:00	SPY	ETF	109.54	109.54	109.44	109.44	5900.0
2009-10-20 04:20:00	SPY	ETF	109.52	109.54	109.52	109.54	1100.0
2009-10-20 04:25:00	SPY	ETF	109.59	109.59	109.59	109.59	100.0
2009-10-20 04:30:00	SPY	ETF	109.61	109.61	109.61	109.61	300.0
2009-10-20 04:45:00	SPY	ETF	109.61	109.61	109.61	109.61	200.0
2009-10-20 05:10:00	SPY	ETF	109.79	109.79	109.79	109.79	100.0
2009-10-20 05:15:00	SPY	ETF	109.75	109.75	109.75	109.75	100.0
2009-10-20 05:35:00	SPY	ETF	109.71	109.73	109.71	109.73	600.0
2009-10-20 05:45:00	SPY	ETF	109.81	109.81	109.81	109.81	100.0
2009-10-20 06:00:00	SPY	ETF	109.86	109.86	109.86	109.86	500.0
2009-10-20 06:05:00	SPY	ETF	109.86	109.86	109.83	109.83	2600.0
2009-10-20 06:10:00	SPY	ETF	109.81	109.81	109.81	109.81	300.0
2009-10-20 06:15:00	SPY	ETF	109.8	109.8	109.8	109.8	500.0
2009-10-20 06:20:00	SPY	ETF	109.81	109.81	109.81	109.81	200.0
2009-10-20 06:25:00	SPY	ETF	109.82	109.82	109.72	109.72	800.0
2009-10-20 06:30:00	SPY	ETF	109.74	109.74	109.7	109.7	1200.0
2009-10-20 06:35:00	SPY	ETF	109.77	109.77	109.77	109.77	200.0
2009-10-20 06:50:00	SPY	ETF	109.72	109.72	109.72	109.72	2500.0
2009-10-20 06:55:00	SPY	ETF	109.72	109.72	109.68	109.68	5300.0
2009-10-20 07:00:00	SPY	ETF	109.71	109.75	109.71	109.75	4509.0
2009-10-20 07:05:00	SPY	ETF	109.73	109.88	109.73	109.87	43642.0
2009-10-20 07:10:00	SPY	ETF	109.88	109.99	109.87	109.99	14650.0
2009-10-20 07:15:00	SPY	ETF	109.95	109.99	109.89	109.89	19450.0
2009-10-20 07:20:00	SPY	ETF	109.9	109.99	109.9	109.99	20356.0
2009-10-20 07:25:00	SPY	ETF	109.97	109.99	109.97	109.97	5800.0
2009-10-20 07:30:00	SPY	ETF	109.97	110.36	109.96	110.28	417793.0
2009-10-20 07:35:00	SPY	ETF	110.26	110.29	110.1	110.1	89306.0
2009-10-20 07:40:00	SPY	ETF	110.14	110.17	110.09	110.12	66900.0
2009-10-20 07:45:00	SPY	ETF	110.12	110.15	110.03	110.15	128920.0
2009-10-20 07:50:00	SPY	ETF	110.17	110.17	110.09	110.14	24132.0
2009-10-20 07:55:00	SPY	ETF	110.13	110.18	110.13	110.17	34611.0
2009-10-20 08:00:00	SPY	ETF	110.14	110.19	109.45	110.15	907238.0
2009-10-20 08:05:00	SPY	ETF	110.15	110.18	110.13	110.17	261529.0
2009-10-20 08:10:00	SPY	ETF	110.18	110.18	110.08	110.13	101165.0
2009-10-20 08:15:00	SPY	ETF	110.13	110.15	110.11	110.13	39661.0
2009-10-20 08:20:00	SPY	ETF	110.13	110.14	110.09	110.12	135835.0
2009-10-20 08:25:00	SPY	ETF	110.12	110.15	109.87	109.97	495374.0
2009-10-20 08:30:00	SPY	ETF	109.95	109.97	109.59	109.82	1515343.0
2009-10-20 08:35:00	SPY	ETF	109.83	109.83	109.6	109.74	617806.0
2009-10-20 08:40:00	SPY	ETF	109.74	109.87	109.71	109.86	382558.0
2009-10-20 08:45:00	SPY	ETF	109.86	109.86	109.75	109.79	171923.0
2009-10-20 08:50:00	SPY	ETF	109.76	109.88	109.76	109.86	197902.0
2009-10-20 08:55:00	SPY	ETF	109.88	109.9	109.83	109.89	164155.0
2009-10-20 09:00:00	SPY	ETF	109.88	109.96	109.86	109.96	214173.0
2009-10-20 09:05:00	SPY	ETF	109.95	110.0	109.95	109.99	368093.0
2009-10-20 09:10:00	SPY	ETF	109.99	110.0	109.91	109.99	213628.0
2009-10-20 09:15:00	SPY	ETF	109.98	110.02	109.96	109.98	552738.0
2009-10-20 09:20:00	SPY	ETF	109.99	110.05	109.98	110.03	282921.0
2009-10-20 09:25:00	SPY	ETF	110.03	110.05	109.95	109.95	313673.0
2009-10-20 09:30:00	SPY	ETF	109.95	109.985	109.58	109.67	5070170.0

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

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