PREVIEW / etf_30min / 2019-04-03

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-03.parquet
  size:    505 KB
  rows:    17,689

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-04-03 04:00:00	SPY	ETF	286.93	287.24	286.93	287.05	12368.0
2019-04-03 04:30:00	SPY	ETF	287.05	287.13	287.01	287.1	4410.0
2019-04-03 05:00:00	SPY	ETF	287.1	287.14	286.99	287.03	7603.0
2019-04-03 05:30:00	SPY	ETF	287.02	287.02	286.96	287.0	2699.0
2019-04-03 06:00:00	SPY	ETF	286.96	287.0	286.85	286.93	69927.0
2019-04-03 06:30:00	SPY	ETF	286.95	287.02	286.92	287.0	22847.0
2019-04-03 07:00:00	SPY	ETF	286.9	287.2	286.89	287.2	86027.0
2019-04-03 07:30:00	SPY	ETF	287.2	287.25	287.15	287.2	57460.0
2019-04-03 08:00:00	SPY	ETF	287.17	287.43	286.9	287.17	300791.0
2019-04-03 08:30:00	SPY	ETF	287.21	287.46	287.21	287.26	189547.0
2019-04-03 09:00:00	SPY	ETF	287.28	287.43	287.16	287.3	226571.0
2019-04-03 09:30:00	SPY	ETF	287.32	287.33	286.73	286.77	6283748.0
2019-04-03 10:00:00	SPY	ETF	286.76	287.11	286.36	286.99	4802744.0
2019-04-03 10:30:00	SPY	ETF	286.99	287.38	286.84	287.31	3824544.0
2019-04-03 11:00:00	SPY	ETF	287.32	287.75	287.3	287.46	3359703.0
2019-04-03 11:30:00	SPY	ETF	287.45	287.76	287.44	287.62	2957524.0
2019-04-03 12:00:00	SPY	ETF	287.63	287.75	287.49	287.52	1786947.0
2019-04-03 12:30:00	SPY	ETF	287.53	287.55	287.22	287.35	1712336.0
2019-04-03 13:00:00	SPY	ETF	287.35	287.51	287.14	287.3	2638944.0
2019-04-03 13:30:00	SPY	ETF	287.29	287.31	286.44	286.5	6776281.0
2019-04-03 14:00:00	SPY	ETF	286.5	286.765	286.27	286.69	2996243.0
2019-04-03 14:30:00	SPY	ETF	286.7	286.7101	286.17	286.3277	4337131.0
2019-04-03 15:00:00	SPY	ETF	286.3238	286.49	285.75	286.255	4789587.0
2019-04-03 15:30:00	SPY	ETF	286.26	286.725	286.09	286.52	11336106.0
2019-04-03 16:00:00	SPY	ETF	286.52	286.86	286.42	286.81	7782557.0
2019-04-03 16:30:00	SPY	ETF	286.81	286.84	286.4053	286.8	366287.0
2019-04-03 17:00:00	SPY	ETF	286.75	286.78	286.75	286.77	24592.0
2019-04-03 17:30:00	SPY	ETF	286.7699	286.9	286.75	286.9	83247.0
2019-04-03 18:00:00	SPY	ETF	286.89	286.95	286.78	286.86	85473.0
2019-04-03 18:30:00	SPY	ETF	286.81	286.88	286.7	286.73	19816.0
2019-04-03 19:00:00	SPY	ETF	286.74	286.88	286.65	286.79	21236.0
2019-04-03 19:30:00	SPY	ETF	286.79	286.79	286.66	286.68	21839.0
2019-04-03 04:00:00	QQQ	ETF	183.92	183.98	183.75	183.79	18920.0
2019-04-03 04:30:00	QQQ	ETF	183.8	183.86	183.77	183.78	1300.0
2019-04-03 05:00:00	QQQ	ETF	183.74	183.81	183.74	183.81	6900.0
2019-04-03 05:30:00	QQQ	ETF	183.76	183.79	183.67	183.69	16107.0
2019-04-03 06:00:00	QQQ	ETF	183.63	183.67	183.57	183.58	6664.0
2019-04-03 06:30:00	QQQ	ETF	183.61	183.68	183.59	183.68	5890.0
2019-04-03 07:00:00	QQQ	ETF	183.57	183.77	183.56	183.76	47989.0
2019-04-03 07:30:00	QQQ	ETF	183.76	183.79	183.68	183.74	138584.0
2019-04-03 08:00:00	QQQ	ETF	183.71	183.93	183.555	183.67	131346.0
2019-04-03 08:30:00	QQQ	ETF	183.71	183.86	183.7	183.76	100632.0
2019-04-03 09:00:00	QQQ	ETF	183.78	183.87	183.7	183.73	57821.0
2019-04-03 09:30:00	QQQ	ETF	183.74	183.88	183.45	183.73	3154998.0
2019-04-03 10:00:00	QQQ	ETF	183.73	184.1	183.42	184.05	2346654.0
2019-04-03 10:30:00	QQQ	ETF	184.04	184.39	183.99	184.3744	2254591.0
2019-04-03 11:00:00	QQQ	ETF	184.38	184.77	184.38	184.6301	2864803.0
2019-04-03 11:30:00	QQQ	ETF	184.62	184.91	184.62	184.7999	2142898.0
2019-04-03 12:00:00	QQQ	ETF	184.7953	184.92	184.69	184.69	1455461.0
2019-04-03 12:30:00	QQQ	ETF	184.695	184.7	184.44	184.505	1028520.0

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

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