PREVIEW / etf_30min / 2019-11-07

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-07.parquet
  size:    535 KB
  rows:    18,838

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-11-07 04:00:00	SPY	ETF	308.61	308.84	308.55	308.73	16046.0
2019-11-07 04:30:00	SPY	ETF	308.71	308.85	308.62	308.73	105267.0
2019-11-07 05:00:00	SPY	ETF	308.74	308.85	308.68	308.77	129419.0
2019-11-07 05:30:00	SPY	ETF	308.74	308.77	308.59	308.71	30130.0
2019-11-07 06:00:00	SPY	ETF	308.7	308.75	308.6	308.63	26698.0
2019-11-07 06:30:00	SPY	ETF	308.64	308.64	308.46	308.46	17710.0
2019-11-07 07:00:00	SPY	ETF	308.46	308.49	308.32	308.39	82444.0
2019-11-07 07:30:00	SPY	ETF	308.43	308.51	308.41	308.46	16330.0
2019-11-07 08:00:00	SPY	ETF	308.44	308.94	307.02	308.56	124785.0
2019-11-07 08:30:00	SPY	ETF	308.56	308.65	308.24	308.4	110778.0
2019-11-07 09:00:00	SPY	ETF	308.39	308.64	308.38	308.59	94917.0
2019-11-07 09:30:00	SPY	ETF	308.57	309.24	308.51	309.035	5298543.0
2019-11-07 10:00:00	SPY	ETF	309.04	309.2	308.75	308.9681	3266558.0
2019-11-07 10:30:00	SPY	ETF	308.97	309.4	308.89	309.21	2533697.0
2019-11-07 11:00:00	SPY	ETF	309.2	309.24	308.91	308.9565	2397709.0
2019-11-07 11:30:00	SPY	ETF	308.95	309.65	308.755	309.38	5103791.0
2019-11-07 12:00:00	SPY	ETF	309.385	309.46	308.87	309.12	3322671.0
2019-11-07 12:30:00	SPY	ETF	309.12	309.16	308.87	309.09	1866333.0
2019-11-07 13:00:00	SPY	ETF	309.1	309.12	308.8241	308.88	1752777.0
2019-11-07 13:30:00	SPY	ETF	308.87	308.88	308.65	308.75	3630299.0
2019-11-07 14:00:00	SPY	ETF	308.7517	308.99	308.74	308.8559	1652877.0
2019-11-07 14:30:00	SPY	ETF	308.8506	308.86	307.93	308.385	4672194.0
2019-11-07 15:00:00	SPY	ETF	308.39	308.56	307.67	308.04	5171860.0
2019-11-07 15:30:00	SPY	ETF	308.03	308.24	307.66	308.22	8154704.0
2019-11-07 16:00:00	SPY	ETF	308.23	308.42	308.11	308.38	3019657.0
2019-11-07 16:30:00	SPY	ETF	308.38	308.45	308.35	308.37	190142.0
2019-11-07 17:00:00	SPY	ETF	308.38	308.46	308.31	308.46	127463.0
2019-11-07 17:30:00	SPY	ETF	308.42	308.44	308.35	308.38	58186.0
2019-11-07 18:00:00	SPY	ETF	308.35	308.36	308.2	308.35	291161.0
2019-11-07 18:30:00	SPY	ETF	308.42	308.45	308.36	308.44	26356.0
2019-11-07 19:00:00	SPY	ETF	308.43	308.78	308.32	308.45	68760.0
2019-11-07 19:30:00	SPY	ETF	308.48	308.48	308.07	308.12	59142.0
2019-11-07 04:00:00	QQQ	ETF	200.94	201.09	200.94	201.02	16235.0
2019-11-07 04:30:00	QQQ	ETF	201.0	201.17	200.95	201.13	14170.0
2019-11-07 05:00:00	QQQ	ETF	201.18	201.18	201.04	201.08	4820.0
2019-11-07 05:30:00	QQQ	ETF	201.1	201.1	200.97	201.08	9750.0
2019-11-07 06:00:00	QQQ	ETF	201.02	201.02	200.92	200.97	9874.0
2019-11-07 06:30:00	QQQ	ETF	200.97	200.97	200.83	200.83	21050.0
2019-11-07 07:00:00	QQQ	ETF	200.89	200.89	200.77	200.84	71955.0
2019-11-07 07:30:00	QQQ	ETF	200.83	200.99	200.83	200.95	29282.0
2019-11-07 08:00:00	QQQ	ETF	200.82	201.08	199.87	200.88	81922.0
2019-11-07 08:30:00	QQQ	ETF	200.94	200.95	200.65	200.73	79336.0
2019-11-07 09:00:00	QQQ	ETF	200.73	200.89	200.71	200.79	71090.0
2019-11-07 09:30:00	QQQ	ETF	200.76	201.23	200.6	201.068	1869052.0
2019-11-07 10:00:00	QQQ	ETF	201.07	201.3427	200.9	201.2566	1035244.0
2019-11-07 10:30:00	QQQ	ETF	201.26	201.54	201.16	201.4	1549876.0
2019-11-07 11:00:00	QQQ	ETF	201.41	201.53	201.3	201.32	745818.0
2019-11-07 11:30:00	QQQ	ETF	201.32	201.72	201.11	201.62	1487003.0
2019-11-07 12:00:00	QQQ	ETF	201.625	201.66	201.25	201.44	915915.0
2019-11-07 12:30:00	QQQ	ETF	201.435	201.44	201.19	201.3783	614549.0

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

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