PREVIEW / etf_5min / 2019-12-26

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-12-26.parquet
  size:    1.4 MB
  rows:    59,916

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
2019-12-26 04:00:00	SPY	ETF	321.54	321.66	321.54	321.66	2444.0
2019-12-26 04:05:00	SPY	ETF	321.75	321.75	321.73	321.73	388.0
2019-12-26 04:15:00	SPY	ETF	321.71	321.71	321.71	321.71	401.0
2019-12-26 04:20:00	SPY	ETF	321.76	321.79	321.76	321.79	4526.0
2019-12-26 04:30:00	SPY	ETF	321.79	321.79	321.79	321.79	101.0
2019-12-26 04:35:00	SPY	ETF	321.78	321.78	321.78	321.78	361.0
2019-12-26 04:55:00	SPY	ETF	321.76	321.76	321.76	321.76	105.0
2019-12-26 05:20:00	SPY	ETF	321.79	321.8	321.79	321.79	1800.0
2019-12-26 05:30:00	SPY	ETF	321.77	321.77	321.77	321.77	100.0
2019-12-26 06:10:00	SPY	ETF	321.77	321.77	321.77	321.77	200.0
2019-12-26 06:45:00	SPY	ETF	321.77	321.77	321.77	321.77	200.0
2019-12-26 06:50:00	SPY	ETF	321.77	321.77	321.75	321.75	200.0
2019-12-26 07:00:00	SPY	ETF	321.75	321.77	321.74	321.741	5755.0
2019-12-26 07:05:00	SPY	ETF	321.78	321.78	321.78	321.78	456.0
2019-12-26 07:10:00	SPY	ETF	321.76	321.77	321.76	321.77	508.0
2019-12-26 07:15:00	SPY	ETF	321.74	321.74	321.74	321.74	109.0
2019-12-26 07:25:00	SPY	ETF	321.73	321.73	321.73	321.73	300.0
2019-12-26 07:30:00	SPY	ETF	321.74	321.74	321.74	321.74	1300.0
2019-12-26 07:40:00	SPY	ETF	321.73	321.74	321.73	321.74	950.0
2019-12-26 07:50:00	SPY	ETF	321.76	321.77	321.7	321.74	7430.0
2019-12-26 07:55:00	SPY	ETF	321.76	321.76	321.76	321.76	1991.0
2019-12-26 08:00:00	SPY	ETF	321.76	321.8	321.7	321.76	9041.0
2019-12-26 08:05:00	SPY	ETF	321.74	321.74	321.74	321.74	250.0
2019-12-26 08:10:00	SPY	ETF	321.73	321.73	321.65	321.68	5528.0
2019-12-26 08:15:00	SPY	ETF	321.67	321.69	321.67	321.69	1040.0
2019-12-26 08:20:00	SPY	ETF	321.69	321.75	321.69	321.74	20492.0
2019-12-26 08:25:00	SPY	ETF	321.74	321.97	321.73	321.95	33106.0
2019-12-26 08:30:00	SPY	ETF	321.87	321.89	321.83	321.84	12934.0
2019-12-26 08:35:00	SPY	ETF	321.8	321.8	321.76	321.78	3837.0
2019-12-26 08:40:00	SPY	ETF	321.78	321.78	321.77	321.78	30533.0
2019-12-26 08:45:00	SPY	ETF	321.78	321.78	321.75	321.75	26891.0
2019-12-26 08:50:00	SPY	ETF	321.77	321.81	321.74	321.81	21312.0
2019-12-26 08:55:00	SPY	ETF	321.81	321.83	321.78	321.8	28478.0
2019-12-26 09:00:00	SPY	ETF	321.75	321.75	321.72	321.72	882.0
2019-12-26 09:05:00	SPY	ETF	321.8	321.8	321.8	321.8	632.0
2019-12-26 09:10:00	SPY	ETF	321.82	321.87	321.8	321.82	18000.0
2019-12-26 09:15:00	SPY	ETF	321.79	321.79	321.79	321.79	119.0
2019-12-26 09:20:00	SPY	ETF	321.79	321.83	321.76	321.8	11306.0
2019-12-26 09:25:00	SPY	ETF	321.79	321.8	321.65	321.65	36966.0
2019-12-26 09:30:00	SPY	ETF	321.65	321.87	321.64	321.81	707233.0
2019-12-26 09:35:00	SPY	ETF	321.81	321.96	321.81	321.96	299406.0
2019-12-26 09:40:00	SPY	ETF	321.97	322.05	321.9315	322.0	424665.0
2019-12-26 09:45:00	SPY	ETF	321.99	322.14	321.98	322.05	304760.0
2019-12-26 09:50:00	SPY	ETF	322.05	322.07	321.95	321.97	337838.0
2019-12-26 09:55:00	SPY	ETF	321.97	322.05	321.94	321.985	180452.0
2019-12-26 10:00:00	SPY	ETF	321.99	322.07	321.98	322.03	229712.0
2019-12-26 10:05:00	SPY	ETF	322.03	322.07	322.01	322.06	246312.0
2019-12-26 10:10:00	SPY	ETF	322.07	322.1	322.01	322.065	165892.0
2019-12-26 10:15:00	SPY	ETF	322.07	322.1	322.035	322.09	125150.0
2019-12-26 10:20:00	SPY	ETF	322.0899	322.15	322.085	322.145	208613.0

> showing 50 of 59,916 rows — these rows as CSV

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