PREVIEW / etf_5min / 2020-03-27

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-27.parquet
  size:    1.9 MB
  rows:    83,821

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
2020-03-27 04:00:00	SPY	ETF	257.11	258.0	256.63	257.67	77710.0
2020-03-27 04:05:00	SPY	ETF	257.7	258.39	257.51	257.92	32788.0
2020-03-27 04:10:00	SPY	ETF	257.94	258.34	257.45	258.0	16631.0
2020-03-27 04:15:00	SPY	ETF	258.17	258.25	256.98	257.4	26871.0
2020-03-27 04:20:00	SPY	ETF	257.09	257.29	256.66	257.29	21406.0
2020-03-27 04:25:00	SPY	ETF	257.27	257.77	256.81	257.77	16094.0
2020-03-27 04:30:00	SPY	ETF	257.72	257.86	257.0	257.02	18823.0
2020-03-27 04:35:00	SPY	ETF	257.46	257.46	256.79	257.23	21475.0
2020-03-27 04:40:00	SPY	ETF	257.22	257.58	257.19	257.36	3569.0
2020-03-27 04:45:00	SPY	ETF	257.22	257.57	257.19	257.21	52471.0
2020-03-27 04:50:00	SPY	ETF	257.0	257.11	256.78	256.94	7897.0
2020-03-27 04:55:00	SPY	ETF	256.86	257.02	256.47	256.52	70688.0
2020-03-27 05:00:00	SPY	ETF	256.59	257.51	256.25	256.37	55370.0
2020-03-27 05:05:00	SPY	ETF	256.29	256.31	255.92	256.31	73393.0
2020-03-27 05:10:00	SPY	ETF	256.21	256.86	256.21	256.49	22035.0
2020-03-27 05:15:00	SPY	ETF	256.48	257.24	256.33	256.9	11432.0
2020-03-27 05:20:00	SPY	ETF	256.88	257.05	256.75	256.75	4868.0
2020-03-27 05:25:00	SPY	ETF	256.57	256.7	256.25	256.25	13701.0
2020-03-27 05:30:00	SPY	ETF	256.11	256.14	255.53	255.86	29037.0
2020-03-27 05:35:00	SPY	ETF	255.69	255.87	255.56	255.66	22232.0
2020-03-27 05:40:00	SPY	ETF	255.68	256.01	255.5	255.82	31861.0
2020-03-27 05:45:00	SPY	ETF	255.8	255.95	255.6	255.95	9831.0
2020-03-27 05:50:00	SPY	ETF	256.0	256.5	255.5	255.5	26398.0
2020-03-27 05:55:00	SPY	ETF	255.54	255.8	255.4	255.48	66769.0
2020-03-27 06:00:00	SPY	ETF	255.44	255.44	254.63	255.13	61280.0
2020-03-27 06:05:00	SPY	ETF	255.02	256.05	254.85	255.07	45318.0
2020-03-27 06:10:00	SPY	ETF	255.01	255.14	254.66	255.0	69588.0
2020-03-27 06:15:00	SPY	ETF	254.9	255.09	254.62	254.65	49333.0
2020-03-27 06:20:00	SPY	ETF	254.9	255.3	254.74	254.74	15986.0
2020-03-27 06:25:00	SPY	ETF	254.83	255.1	254.74	255.07	24221.0
2020-03-27 06:30:00	SPY	ETF	255.15	256.71	254.79	256.68	32853.0
2020-03-27 06:35:00	SPY	ETF	256.55	257.14	255.9	255.9	71703.0
2020-03-27 06:40:00	SPY	ETF	255.81	256.5	255.42	256.41	37548.0
2020-03-27 06:45:00	SPY	ETF	256.4	256.7	255.75	255.9	22548.0
2020-03-27 06:50:00	SPY	ETF	255.7	255.7	255.29	255.29	31081.0
2020-03-27 06:55:00	SPY	ETF	255.2	255.26	254.33	254.36	53793.0
2020-03-27 07:00:00	SPY	ETF	254.57	255.54	254.46	255.44	129613.0
2020-03-27 07:05:00	SPY	ETF	255.3	256.06	255.25	255.7	60814.0
2020-03-27 07:10:00	SPY	ETF	255.77	256.28	255.54	255.91	67297.0
2020-03-27 07:15:00	SPY	ETF	255.99	256.17	255.48	255.64	69764.0
2020-03-27 07:20:00	SPY	ETF	255.65	255.73	254.7	254.7	103236.0
2020-03-27 07:25:00	SPY	ETF	254.67	255.1	254.49	254.57	141968.0
2020-03-27 07:30:00	SPY	ETF	254.6	254.88	254.0	254.0	159371.0
2020-03-27 07:35:00	SPY	ETF	254.0	254.83	253.98	254.28	171975.0
2020-03-27 07:40:00	SPY	ETF	254.58	255.21	254.13	254.86	110217.0
2020-03-27 07:45:00	SPY	ETF	254.92	255.5	254.05	254.17	182721.0
2020-03-27 07:50:00	SPY	ETF	254.19	254.36	253.45	253.69	194221.0
2020-03-27 07:55:00	SPY	ETF	253.74	254.25	253.44	253.68	189423.0
2020-03-27 08:00:00	SPY	ETF	253.67	260.42	252.98	253.69	425173.0
2020-03-27 08:05:00	SPY	ETF	253.67	253.95	253.33	253.3502	269565.0

> showing 50 of 83,821 rows — these rows as CSV

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