PREVIEW / etf_30min / 2019-05-02

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-02.parquet
  size:    499 KB
  rows:    17,303

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-05-02 04:00:00	SPY	ETF	292.11	292.29	292.04	292.16	29769.0
2019-05-02 04:30:00	SPY	ETF	292.22	292.43	292.21	292.4	5245.0
2019-05-02 05:00:00	SPY	ETF	292.34	292.56	292.34	292.52	6293.0
2019-05-02 05:30:00	SPY	ETF	292.53	292.6	292.48	292.6	29111.0
2019-05-02 06:00:00	SPY	ETF	292.51	292.51	292.23	292.25	20505.0
2019-05-02 06:30:00	SPY	ETF	292.25	292.56	292.25	292.3	73002.0
2019-05-02 07:00:00	SPY	ETF	292.3	292.33	291.92	292.04	75238.0
2019-05-02 07:30:00	SPY	ETF	292.04	292.24	292.0	292.07	101129.0
2019-05-02 08:00:00	SPY	ETF	292.08	292.4	291.71	291.85	221299.0
2019-05-02 08:30:00	SPY	ETF	291.88	292.03	291.52	291.71	197150.0
2019-05-02 09:00:00	SPY	ETF	291.7	291.76	291.56	291.68	229735.0
2019-05-02 09:30:00	SPY	ETF	291.68	292.3	291.3399	292.1669	5943014.0
2019-05-02 10:00:00	SPY	ETF	292.165	292.7	292.165	292.32	4266190.0
2019-05-02 10:30:00	SPY	ETF	292.325	292.56	291.6	291.61	3505956.0
2019-05-02 11:00:00	SPY	ETF	291.62	291.95	290.45	290.4838	6805210.0
2019-05-02 11:30:00	SPY	ETF	290.48	291.0	289.52	290.01	8309737.0
2019-05-02 12:00:00	SPY	ETF	290.0	290.42	289.72	290.33	5067133.0
2019-05-02 12:30:00	SPY	ETF	290.33	290.79	290.25	290.52	3688215.0
2019-05-02 13:00:00	SPY	ETF	290.52	291.24	290.0999	291.03	3678368.0
2019-05-02 13:30:00	SPY	ETF	291.0224	291.37	290.84	290.985	3107120.0
2019-05-02 14:00:00	SPY	ETF	290.98	291.48	290.87	291.15	2611395.0
2019-05-02 14:30:00	SPY	ETF	291.15	291.38	290.4	290.76	2645399.0
2019-05-02 15:00:00	SPY	ETF	290.75	291.3	290.66	291.17	2179980.0
2019-05-02 15:30:00	SPY	ETF	291.17	291.3277	290.72	291.27	7374050.0
2019-05-02 16:00:00	SPY	ETF	291.26	291.2804	290.93	291.18	2758287.0
2019-05-02 16:30:00	SPY	ETF	291.18	291.37	291.13	291.31	194556.0
2019-05-02 17:00:00	SPY	ETF	291.3	291.32	291.24	291.25	118287.0
2019-05-02 17:30:00	SPY	ETF	291.29	291.35	291.27	291.27	28549.0
2019-05-02 18:00:00	SPY	ETF	291.29	291.51	291.23	291.34	28030.0
2019-05-02 18:30:00	SPY	ETF	291.37	291.42	291.32	291.32	8454.0
2019-05-02 19:00:00	SPY	ETF	291.41	291.45	291.35	291.37	5017.0
2019-05-02 19:30:00	SPY	ETF	291.35	291.47	291.35	291.37	14826.0
2019-05-02 04:00:00	QQQ	ETF	189.05	189.08	188.93	189.08	21920.0
2019-05-02 04:30:00	QQQ	ETF	189.09	189.24	189.06	189.24	29442.0
2019-05-02 05:00:00	QQQ	ETF	189.21	189.4	189.18	189.38	37889.0
2019-05-02 05:30:00	QQQ	ETF	189.39	189.45	189.37	189.45	26034.0
2019-05-02 06:00:00	QQQ	ETF	189.44	189.44	189.24	189.24	12073.0
2019-05-02 06:30:00	QQQ	ETF	189.21	189.42	189.21	189.26	13350.0
2019-05-02 07:00:00	QQQ	ETF	189.27	189.29	189.01	189.13	38600.0
2019-05-02 07:30:00	QQQ	ETF	189.11	189.3	189.03	189.2	54679.0
2019-05-02 08:00:00	QQQ	ETF	189.2801	189.2801	188.93	188.97	104543.0
2019-05-02 08:30:00	QQQ	ETF	189.13	189.18	188.74	188.88	84985.0
2019-05-02 09:00:00	QQQ	ETF	188.86	188.92	188.76	188.88	85692.0
2019-05-02 09:30:00	QQQ	ETF	188.88	189.4	188.61	189.222	3536479.0
2019-05-02 10:00:00	QQQ	ETF	189.23	189.85	189.22	189.34	2266238.0
2019-05-02 10:30:00	QQQ	ETF	189.335	189.62	188.87	188.89	1319434.0
2019-05-02 11:00:00	QQQ	ETF	188.91	189.25	188.04	188.0635	3604032.0
2019-05-02 11:30:00	QQQ	ETF	188.06	188.5599	186.87	187.19	4912208.0
2019-05-02 12:00:00	QQQ	ETF	187.19	187.64	187.05	187.5834	3653587.0
2019-05-02 12:30:00	QQQ	ETF	187.59	187.94	187.33	187.49	2111901.0

> showing 50 of 17,303 rows — these rows as CSV

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