PREVIEW / etf_5min / 2020-04-20

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-20.parquet
  size:    1.8 MB
  rows:    79,341

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-04-20 04:00:00	SPY	ETF	285.84	285.84	285.5	285.5	13596.0
2020-04-20 04:05:00	SPY	ETF	285.5	285.67	285.36	285.46	9470.0
2020-04-20 04:10:00	SPY	ETF	285.32	285.41	285.27	285.37	11932.0
2020-04-20 04:15:00	SPY	ETF	285.22	285.4	285.18	285.24	8560.0
2020-04-20 04:20:00	SPY	ETF	285.39	285.4	284.86	284.86	8842.0
2020-04-20 04:25:00	SPY	ETF	284.85	284.9	284.67	284.67	22792.0
2020-04-20 04:30:00	SPY	ETF	284.62	284.81	284.57	284.74	11605.0
2020-04-20 04:35:00	SPY	ETF	284.79	284.87	284.79	284.87	3110.0
2020-04-20 04:40:00	SPY	ETF	284.87	284.97	284.87	284.9	4630.0
2020-04-20 04:45:00	SPY	ETF	284.88	285.12	284.88	285.0	6154.0
2020-04-20 04:50:00	SPY	ETF	284.9	284.99	284.9	284.99	1500.0
2020-04-20 04:55:00	SPY	ETF	284.94	285.15	284.94	285.15	1944.0
2020-04-20 05:00:00	SPY	ETF	285.3	285.3	285.14	285.14	879.0
2020-04-20 05:05:00	SPY	ETF	285.29	285.29	285.12	285.14	2761.0
2020-04-20 05:10:00	SPY	ETF	285.38	285.39	285.27	285.27	5618.0
2020-04-20 05:15:00	SPY	ETF	285.34	285.35	285.23	285.23	880.0
2020-04-20 05:20:00	SPY	ETF	285.1	285.24	284.99	285.16	32010.0
2020-04-20 05:25:00	SPY	ETF	285.0	285.13	285.0	285.05	7603.0
2020-04-20 05:30:00	SPY	ETF	285.07	285.11	285.0	285.0	54080.0
2020-04-20 05:35:00	SPY	ETF	284.9	285.0	284.5	284.56	12412.0
2020-04-20 05:40:00	SPY	ETF	284.59	284.94	284.59	284.94	2335.0
2020-04-20 05:45:00	SPY	ETF	285.0	285.0	284.6	284.67	16738.0
2020-04-20 05:50:00	SPY	ETF	284.7	284.75	284.28	284.28	15925.0
2020-04-20 05:55:00	SPY	ETF	284.25	284.28	283.83	283.83	27668.0
2020-04-20 06:00:00	SPY	ETF	284.03	284.05	283.5	283.51	14319.0
2020-04-20 06:05:00	SPY	ETF	283.49	283.56	283.03	283.32	22322.0
2020-04-20 06:10:00	SPY	ETF	283.34	283.49	283.29	283.3	5312.0
2020-04-20 06:15:00	SPY	ETF	283.3	283.61	283.3	283.4	20519.0
2020-04-20 06:20:00	SPY	ETF	283.33	283.33	282.52	282.62	14435.0
2020-04-20 06:25:00	SPY	ETF	282.63	282.8	282.44	282.75	97743.0
2020-04-20 06:30:00	SPY	ETF	282.73	283.08	282.72	283.0	58217.0
2020-04-20 06:35:00	SPY	ETF	282.97	283.03	282.85	283.03	8295.0
2020-04-20 06:40:00	SPY	ETF	283.13	283.23	282.67	282.77	21678.0
2020-04-20 06:45:00	SPY	ETF	282.76	283.05	282.76	282.83	31257.0
2020-04-20 06:50:00	SPY	ETF	282.8	282.93	282.64	282.93	102098.0
2020-04-20 06:55:00	SPY	ETF	282.92	282.99	282.8	282.85	84971.0
2020-04-20 07:00:00	SPY	ETF	282.85	283.3	282.7	283.14	155251.0
2020-04-20 07:05:00	SPY	ETF	283.22	283.34	282.79	282.93	72606.0
2020-04-20 07:10:00	SPY	ETF	282.93	283.17	282.73	282.88	131586.0
2020-04-20 07:15:00	SPY	ETF	282.81	282.87	282.19	282.19	230005.0
2020-04-20 07:20:00	SPY	ETF	282.19	282.31	281.87	282.1	151388.0
2020-04-20 07:25:00	SPY	ETF	282.15	282.21	281.84	282.0	106253.0
2020-04-20 07:30:00	SPY	ETF	282.0	282.53	281.8	282.49	218037.0
2020-04-20 07:35:00	SPY	ETF	282.5	282.51	282.15	282.21	110213.0
2020-04-20 07:40:00	SPY	ETF	282.23	282.28	281.94	282.17	66808.0
2020-04-20 07:45:00	SPY	ETF	282.2	282.3	281.51	281.76	144659.0
2020-04-20 07:50:00	SPY	ETF	281.75	281.9	281.25	281.65	123240.0
2020-04-20 07:55:00	SPY	ETF	281.63	281.76	281.28	281.53	86579.0
2020-04-20 08:00:00	SPY	ETF	281.4	287.61	281.28	281.49	490682.0
2020-04-20 08:05:00	SPY	ETF	281.48	282.07	281.28	281.95	88140.0

> showing 50 of 79,341 rows — these rows as CSV

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