PREVIEW / etf_30min / 2018-12-10

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-10.parquet
  size:    517 KB
  rows:    18,066

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
2018-12-10 04:00:00	SPY	ETF	262.7	263.11	262.51	262.84	24964.0
2018-12-10 04:30:00	SPY	ETF	262.66	263.14	262.66	263.0	11875.0
2018-12-10 05:00:00	SPY	ETF	263.04	263.19	262.86	262.91	11570.0
2018-12-10 05:30:00	SPY	ETF	262.95	263.28	262.84	263.26	9375.0
2018-12-10 06:00:00	SPY	ETF	263.27	263.51	263.15	263.18	30927.0
2018-12-10 06:30:00	SPY	ETF	263.16	263.25	262.86	263.18	135750.0
2018-12-10 07:00:00	SPY	ETF	263.2	263.35	262.84	262.87	122633.0
2018-12-10 07:30:00	SPY	ETF	262.96	264.16	262.91	263.94	261999.0
2018-12-10 08:00:00	SPY	ETF	263.96	264.77	262.0	264.35	306802.0
2018-12-10 08:30:00	SPY	ETF	264.35	264.43	263.9	263.9	296612.0
2018-12-10 09:00:00	SPY	ETF	263.89	263.92	263.34	263.37	498039.0
2018-12-10 09:30:00	SPY	ETF	263.37	264.21	261.27	261.67	15753572.0
2018-12-10 10:00:00	SPY	ETF	261.66	263.26	261.325	262.35	11589472.0
2018-12-10 10:30:00	SPY	ETF	262.35	262.74	260.14	260.49	13262775.0
2018-12-10 11:00:00	SPY	ETF	260.4925	260.59	258.62	259.66	17776307.0
2018-12-10 11:30:00	SPY	ETF	259.65	261.27	259.36	260.26	11136148.0
2018-12-10 12:00:00	SPY	ETF	260.25	260.93	259.615	259.985	7759815.0
2018-12-10 12:30:00	SPY	ETF	259.98	262.78	259.97	262.29	10625729.0
2018-12-10 13:00:00	SPY	ETF	262.29	262.97	261.8315	261.94	7758457.0
2018-12-10 13:30:00	SPY	ETF	261.94	263.6199	261.85	263.0213	7102216.0
2018-12-10 14:00:00	SPY	ETF	263.03	263.5	262.33	263.15	7018109.0
2018-12-10 14:30:00	SPY	ETF	263.15	264.4	263.09	263.3	8096458.0
2018-12-10 15:00:00	SPY	ETF	263.3	263.69	262.71	263.69	6524499.0
2018-12-10 15:30:00	SPY	ETF	263.67	265.1613	263.67	264.08	17441284.0
2018-12-10 16:00:00	SPY	ETF	264.06	264.77	264.04	264.59	5325179.0
2018-12-10 16:30:00	SPY	ETF	264.6	264.88	264.07	264.46	368793.0
2018-12-10 17:00:00	SPY	ETF	264.48	264.5	264.23	264.25	176117.0
2018-12-10 17:30:00	SPY	ETF	264.25	264.69	264.07	264.69	79035.0
2018-12-10 18:00:00	SPY	ETF	264.65	264.65	264.11	264.28	111847.0
2018-12-10 18:30:00	SPY	ETF	264.28	264.29	263.9	264.03	64973.0
2018-12-10 19:00:00	SPY	ETF	264.07	264.21	263.76	263.9	87084.0
2018-12-10 19:30:00	SPY	ETF	263.84	263.94	263.42	263.52	100515.0
2018-12-10 04:00:00	QQQ	ETF	160.4	160.96	160.4	160.63	27073.0
2018-12-10 04:30:00	QQQ	ETF	160.63	161.0	160.63	161.0	21154.0
2018-12-10 05:00:00	QQQ	ETF	160.89	161.09	160.83	161.0	5856.0
2018-12-10 05:30:00	QQQ	ETF	160.83	161.22	160.83	161.2	5797.0
2018-12-10 06:00:00	QQQ	ETF	161.2	161.37	161.08	161.25	29317.0
2018-12-10 06:30:00	QQQ	ETF	161.2	161.26	161.11	161.21	30614.0
2018-12-10 07:00:00	QQQ	ETF	161.19	161.26	160.9	160.97	132488.0
2018-12-10 07:30:00	QQQ	ETF	160.99	162.0	160.96	161.77	129008.0
2018-12-10 08:00:00	QQQ	ETF	160.98	162.42	160.3	162.1	191456.0
2018-12-10 08:30:00	QQQ	ETF	162.08	162.16	161.61	161.61	321534.0
2018-12-10 09:00:00	QQQ	ETF	161.62	161.62	161.04	161.12	436293.0
2018-12-10 09:30:00	QQQ	ETF	161.11	162.76	160.56	160.96	8497637.0
2018-12-10 10:00:00	QQQ	ETF	160.96	162.36	160.77	161.51	6641402.0
2018-12-10 10:30:00	QQQ	ETF	161.52	161.82	160.35	160.6099	6184458.0
2018-12-10 11:00:00	QQQ	ETF	160.61	160.67	159.41	160.19	6721669.0
2018-12-10 11:30:00	QQQ	ETF	160.17	161.34	160.09	160.6	5708999.0
2018-12-10 12:00:00	QQQ	ETF	160.59	160.975	160.01	160.18	2998255.0
2018-12-10 12:30:00	QQQ	ETF	160.17	162.39	160.14	161.99	4322268.0

> showing 50 of 18,066 rows — these rows as CSV

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