PREVIEW / etf_30min / 2018-12-17

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-17.parquet
  size:    528 KB
  rows:    18,305

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-17 04:00:00	SPY	ETF	260.99	260.99	260.64	260.69	16938.0
2018-12-17 04:30:00	SPY	ETF	260.75	260.78	260.57	260.78	4203.0
2018-12-17 05:00:00	SPY	ETF	260.82	261.25	260.82	261.24	15366.0
2018-12-17 05:30:00	SPY	ETF	261.28	261.28	260.71	260.72	21845.0
2018-12-17 06:00:00	SPY	ETF	260.73	260.78	260.33	260.37	19360.0
2018-12-17 06:30:00	SPY	ETF	260.31	260.54	260.17	260.44	32499.0
2018-12-17 07:00:00	SPY	ETF	260.4	260.58	260.13	260.35	76935.0
2018-12-17 07:30:00	SPY	ETF	260.37	260.46	259.88	259.98	119504.0
2018-12-17 08:00:00	SPY	ETF	260.0	261.58	259.75	259.84	168409.0
2018-12-17 08:30:00	SPY	ETF	259.84	260.47	259.22	259.29	445173.0
2018-12-17 09:00:00	SPY	ETF	259.31	259.66	259.17	259.41	297060.0
2018-12-17 09:30:00	SPY	ETF	259.4	259.49	257.241	258.4501	12949804.0
2018-12-17 10:00:00	SPY	ETF	258.44	259.27	258.0015	258.86	9389829.0
2018-12-17 10:30:00	SPY	ETF	258.85	259.8	258.175	259.55	8449645.0
2018-12-17 11:00:00	SPY	ETF	259.56	260.65	259.44	259.97	7772416.0
2018-12-17 11:30:00	SPY	ETF	259.96	260.3885	259.4	260.3485	5536118.0
2018-12-17 12:00:00	SPY	ETF	260.35	260.64	259.37	259.4901	5376960.0
2018-12-17 12:30:00	SPY	ETF	259.49	259.49	257.65	257.67	7030040.0
2018-12-17 13:00:00	SPY	ETF	257.66	258.14	257.08	257.4475	8608724.0
2018-12-17 13:30:00	SPY	ETF	257.455	257.82	256.33	256.39	10271007.0
2018-12-17 14:00:00	SPY	ETF	256.37	256.76	255.77	256.0	12342859.0
2018-12-17 14:30:00	SPY	ETF	256.01	256.8	255.57	255.875	10042637.0
2018-12-17 15:00:00	SPY	ETF	255.88	256.2123	254.4	254.67	15065320.0
2018-12-17 15:30:00	SPY	ETF	254.68	255.38	253.525	255.28	31561777.0
2018-12-17 16:00:00	SPY	ETF	255.34	255.86	255.09	255.6	13214904.0
2018-12-17 16:30:00	SPY	ETF	255.57	256.0	255.036	255.78	1847278.0
2018-12-17 17:00:00	SPY	ETF	255.88	255.92	255.17	255.7499	1740792.0
2018-12-17 17:30:00	SPY	ETF	255.75	255.92	255.36	255.92	113660.0
2018-12-17 18:00:00	SPY	ETF	255.91	256.6	255.75	256.19	155818.0
2018-12-17 18:30:00	SPY	ETF	256.18	256.47	256.04	256.41	44184.0
2018-12-17 19:00:00	SPY	ETF	256.4	256.4	255.8	256.02	65562.0
2018-12-17 19:30:00	SPY	ETF	255.98	256.35	255.9	256.33	39761.0
2018-12-17 04:00:00	QQQ	ETF	161.4	161.4	161.0	161.14	10940.0
2018-12-17 04:30:00	QQQ	ETF	161.17	161.24	161.12	161.2	1800.0
2018-12-17 05:00:00	QQQ	ETF	161.41	161.65	161.4	161.54	5830.0
2018-12-17 05:30:00	QQQ	ETF	161.6	161.6	161.28	161.28	8648.0
2018-12-17 06:00:00	QQQ	ETF	161.24	161.25	161.01	161.01	9600.0
2018-12-17 06:30:00	QQQ	ETF	160.98	161.1	160.75	160.97	30615.0
2018-12-17 07:00:00	QQQ	ETF	160.91	161.11	160.65	160.82	45731.0
2018-12-17 07:30:00	QQQ	ETF	160.82	160.92	160.58	160.65	106032.0
2018-12-17 08:00:00	QQQ	ETF	160.68	161.8	160.53	160.65	145781.0
2018-12-17 08:30:00	QQQ	ETF	160.61	160.65	160.17	160.27	224992.0
2018-12-17 09:00:00	QQQ	ETF	160.23	160.55	160.12	160.4	332118.0
2018-12-17 09:30:00	QQQ	ETF	160.41	160.55	158.64	159.42	8279066.0
2018-12-17 10:00:00	QQQ	ETF	159.41	160.68	159.23	160.3962	4141367.0
2018-12-17 10:30:00	QQQ	ETF	160.38	160.88	159.63	160.59	3240784.0
2018-12-17 11:00:00	QQQ	ETF	160.6	161.41	160.53	161.02	3755263.0
2018-12-17 11:30:00	QQQ	ETF	161.01	161.36	160.51	161.35	2235145.0
2018-12-17 12:00:00	QQQ	ETF	161.35	161.67	160.73	160.8321	2020340.0
2018-12-17 12:30:00	QQQ	ETF	160.82	160.85	159.55	159.56	2764427.0

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

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