PREVIEW / etf_30min / 2019-02-12

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-12.parquet
  size:    493 KB
  rows:    17,299

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-02-12 04:00:00	SPY	ETF	272.1	272.36	272.1	272.12	31745.0
2019-02-12 04:30:00	SPY	ETF	272.04	272.12	272.04	272.05	1708.0
2019-02-12 05:00:00	SPY	ETF	272.13	272.35	272.13	272.3	5300.0
2019-02-12 05:30:00	SPY	ETF	272.27	272.43	272.25	272.4	4766.0
2019-02-12 06:00:00	SPY	ETF	272.35	272.49	272.29	272.49	47550.0
2019-02-12 06:30:00	SPY	ETF	272.4	272.6	272.4	272.57	35570.0
2019-02-12 07:00:00	SPY	ETF	272.54	272.67	272.5	272.59	79776.0
2019-02-12 07:30:00	SPY	ETF	272.55	272.72	272.42	272.43	179241.0
2019-02-12 08:00:00	SPY	ETF	272.44	272.63	271.79	272.49	149134.0
2019-02-12 08:30:00	SPY	ETF	272.48	272.56	272.34	272.39	225004.0
2019-02-12 09:00:00	SPY	ETF	272.36	272.62	272.36	272.41	337003.0
2019-02-12 09:30:00	SPY	ETF	272.42	273.15	272.34	273.01	7540982.0
2019-02-12 10:00:00	SPY	ETF	273.02	273.29	272.85	273.01	6601947.0
2019-02-12 10:30:00	SPY	ETF	273.01	273.64	272.72	273.56	4354347.0
2019-02-12 11:00:00	SPY	ETF	273.56	273.96	273.55	273.87	4656169.0
2019-02-12 11:30:00	SPY	ETF	273.88	274.12	273.7	274.08	3097452.0
2019-02-12 12:00:00	SPY	ETF	274.08	274.2	273.62	273.8	3934898.0
2019-02-12 12:30:00	SPY	ETF	273.8	274.04	273.66	273.88	2484931.0
2019-02-12 13:00:00	SPY	ETF	273.89	274.21	273.83	274.15	2332177.0
2019-02-12 13:30:00	SPY	ETF	274.16	274.515	274.155	274.5	5228626.0
2019-02-12 14:00:00	SPY	ETF	274.505	274.52	274.23	274.34	3263601.0
2019-02-12 14:30:00	SPY	ETF	274.345	274.41	274.12	274.1599	4258652.0
2019-02-12 15:00:00	SPY	ETF	274.14	274.47	274.09	274.3964	4309019.0
2019-02-12 15:30:00	SPY	ETF	274.4	274.419	273.9	274.12	9977088.0
2019-02-12 16:00:00	SPY	ETF	274.12	274.29	273.95	274.25	7564039.0
2019-02-12 16:30:00	SPY	ETF	274.26	274.35	274.12	274.24	154891.0
2019-02-12 17:00:00	SPY	ETF	274.27	274.27	274.13	274.15	41937.0
2019-02-12 17:30:00	SPY	ETF	274.17	274.17	274.11	274.11	23476.0
2019-02-12 18:00:00	SPY	ETF	274.14	274.27	274.04	274.25	31819.0
2019-02-12 18:30:00	SPY	ETF	274.26	274.46	274.26	274.4	51346.0
2019-02-12 19:00:00	SPY	ETF	274.41	275.19	274.32	274.81	121610.0
2019-02-12 19:30:00	SPY	ETF	274.81	274.96	274.75	274.79	53574.0
2019-02-12 04:00:00	QQQ	ETF	169.53	169.69	169.49	169.51	14493.0
2019-02-12 04:30:00	QQQ	ETF	169.48	169.57	169.46	169.55	10980.0
2019-02-12 05:00:00	QQQ	ETF	169.54	169.78	169.54	169.75	16928.0
2019-02-12 05:30:00	QQQ	ETF	169.7	169.82	169.66	169.74	6518.0
2019-02-12 06:00:00	QQQ	ETF	169.75	169.83	169.71	169.79	58614.0
2019-02-12 06:30:00	QQQ	ETF	169.82	169.86	169.73	169.85	11365.0
2019-02-12 07:00:00	QQQ	ETF	169.84	169.84	169.75	169.77	90253.0
2019-02-12 07:30:00	QQQ	ETF	169.79	169.94	169.73	169.73	108963.0
2019-02-12 08:00:00	QQQ	ETF	169.8	169.92	169.53	169.72	123790.0
2019-02-12 08:30:00	QQQ	ETF	169.71	169.76	169.55	169.58	59188.0
2019-02-12 09:00:00	QQQ	ETF	169.61	169.78	169.54	169.57	99594.0
2019-02-12 09:30:00	QQQ	ETF	169.57	170.16	169.33	170.02	3397668.0
2019-02-12 10:00:00	QQQ	ETF	170.03	170.4168	170.03	170.24	2245283.0
2019-02-12 10:30:00	QQQ	ETF	170.24	170.75	170.015	170.71	2403260.0
2019-02-12 11:00:00	QQQ	ETF	170.7	170.875	170.595	170.7199	2079102.0
2019-02-12 11:30:00	QQQ	ETF	170.715	170.82	170.61	170.77	968653.0
2019-02-12 12:00:00	QQQ	ETF	170.77	170.86	170.53	170.6	1278143.0
2019-02-12 12:30:00	QQQ	ETF	170.6	170.79	170.54	170.66	924087.0

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

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