PREVIEW / etf_30min / 2020-01-13

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-13.parquet
  size:    547 KB
  rows:    19,424

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
2020-01-13 04:00:00	SPY	ETF	326.67	326.75	326.56	326.7	9276.0
2020-01-13 04:30:00	SPY	ETF	326.65	326.92	326.65	326.84	11646.0
2020-01-13 05:00:00	SPY	ETF	326.93	326.93	326.77	326.83	6301.0
2020-01-13 05:30:00	SPY	ETF	326.84	326.89	326.79	326.89	3546.0
2020-01-13 06:00:00	SPY	ETF	326.86	326.91	326.72	326.76	12250.0
2020-01-13 06:30:00	SPY	ETF	326.74	326.74	326.26	326.31	25988.0
2020-01-13 07:00:00	SPY	ETF	326.27	326.57	326.21	326.53	47628.0
2020-01-13 07:30:00	SPY	ETF	326.53	326.62	326.42	326.49	88754.0
2020-01-13 08:00:00	SPY	ETF	326.49	326.83	326.22	326.76	180831.0
2020-01-13 08:30:00	SPY	ETF	326.76	326.78	325.71	326.54	127655.0
2020-01-13 09:00:00	SPY	ETF	326.54	326.56	326.36	326.4	143273.0
2020-01-13 09:30:00	SPY	ETF	326.39	326.72	325.92	326.65	4462613.0
2020-01-13 10:00:00	SPY	ETF	326.65	326.7	326.3	326.595	1918190.0
2020-01-13 10:30:00	SPY	ETF	326.6	326.94	326.39	326.855	3128659.0
2020-01-13 11:00:00	SPY	ETF	326.85	327.25	326.73	326.92	3119834.0
2020-01-13 11:30:00	SPY	ETF	326.93	327.29	326.79	327.27	2319014.0
2020-01-13 12:00:00	SPY	ETF	327.27	327.545	327.26	327.41	1747762.0
2020-01-13 12:30:00	SPY	ETF	327.41	327.52	327.25	327.31	3064647.0
2020-01-13 13:00:00	SPY	ETF	327.31	327.4599	327.24	327.315	1568434.0
2020-01-13 13:30:00	SPY	ETF	327.3139	327.35	327.19	327.23	2578295.0
2020-01-13 14:00:00	SPY	ETF	327.23	327.5	327.13	327.4801	2207875.0
2020-01-13 14:30:00	SPY	ETF	327.49	327.6	327.43	327.55	1729245.0
2020-01-13 15:00:00	SPY	ETF	327.55	327.61	327.34	327.3675	2163326.0
2020-01-13 15:30:00	SPY	ETF	327.37	327.96	327.35	327.94	6683647.0
2020-01-13 16:00:00	SPY	ETF	327.94	328.06	327.7312	328.0	3542775.0
2020-01-13 16:30:00	SPY	ETF	328.02	328.1501	327.8	327.92	659219.0
2020-01-13 17:00:00	SPY	ETF	327.99	327.99	327.92	327.98	60832.0
2020-01-13 17:30:00	SPY	ETF	327.98	328.1	327.97	328.03	97712.0
2020-01-13 18:00:00	SPY	ETF	328.04	328.24	327.97	328.21	83935.0
2020-01-13 18:30:00	SPY	ETF	328.18	328.46	328.17	328.39	48010.0
2020-01-13 19:00:00	SPY	ETF	328.37	328.69	328.37	328.64	62283.0
2020-01-13 19:30:00	SPY	ETF	328.63	328.64	328.48	328.55	32573.0
2020-01-13 04:00:00	QQQ	ETF	219.27	219.37	219.2	219.26	8550.0
2020-01-13 04:30:00	QQQ	ETF	219.29	219.47	219.29	219.45	21962.0
2020-01-13 05:00:00	QQQ	ETF	219.5	219.5	219.39	219.46	7030.0
2020-01-13 05:30:00	QQQ	ETF	219.41	219.53	219.39	219.39	18724.0
2020-01-13 06:00:00	QQQ	ETF	219.48	219.48	219.36	219.39	11120.0
2020-01-13 06:30:00	QQQ	ETF	219.45	219.45	219.08	219.1	18115.0
2020-01-13 07:00:00	QQQ	ETF	219.06	219.25	219.06	219.25	22868.0
2020-01-13 07:30:00	QQQ	ETF	219.24	219.28	219.11	219.22	21770.0
2020-01-13 08:00:00	QQQ	ETF	219.18	219.47	219.04	219.43	76129.0
2020-01-13 08:30:00	QQQ	ETF	219.45	219.45	219.19	219.28	53998.0
2020-01-13 09:00:00	QQQ	ETF	219.25	219.3	219.14	219.3	58724.0
2020-01-13 09:30:00	QQQ	ETF	219.31	219.79	218.98	219.68	2416642.0
2020-01-13 10:00:00	QQQ	ETF	219.68	219.75	219.42	219.65	970580.0
2020-01-13 10:30:00	QQQ	ETF	219.65	219.805	219.3699	219.735	1102754.0
2020-01-13 11:00:00	QQQ	ETF	219.74	220.22	219.64	219.9	1471593.0
2020-01-13 11:30:00	QQQ	ETF	219.91	220.3	219.82	220.29	1302498.0
2020-01-13 12:00:00	QQQ	ETF	220.29	220.49	220.29	220.415	902981.0
2020-01-13 12:30:00	QQQ	ETF	220.43	220.56	220.3401	220.44	551993.0

> showing 50 of 19,424 rows — these rows as CSV

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