PREVIEW / etf_30min / 2020-07-16

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-16.parquet
  size:    538 KB
  rows:    20,107

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-07-16 04:00:00	SPY	ETF	320.12	320.35	319.59	319.6	29757.0
2020-07-16 04:30:00	SPY	ETF	319.6	319.6	319.2	319.59	41189.0
2020-07-16 05:00:00	SPY	ETF	319.5	319.5	318.92	319.47	28116.0
2020-07-16 05:30:00	SPY	ETF	319.46	319.78	319.32	319.44	25439.0
2020-07-16 06:00:00	SPY	ETF	319.5	319.82	319.49	319.49	18470.0
2020-07-16 06:30:00	SPY	ETF	319.42	319.98	319.38	319.89	44499.0
2020-07-16 07:00:00	SPY	ETF	319.96	320.22	319.73	320.07	140057.0
2020-07-16 07:30:00	SPY	ETF	320.13	320.37	319.88	319.97	177460.0
2020-07-16 08:00:00	SPY	ETF	319.9999	321.15	319.5596	320.01	330248.0
2020-07-16 08:30:00	SPY	ETF	320.0	320.07	319.32	319.65	531551.0
2020-07-16 09:00:00	SPY	ETF	319.62	320.45	319.46	319.78	422033.0
2020-07-16 09:30:00	SPY	ETF	319.79	320.46	319.1	319.73	7102727.0
2020-07-16 10:00:00	SPY	ETF	319.7365	320.33	319.09	320.24	4698509.0
2020-07-16 10:30:00	SPY	ETF	320.2484	320.73	319.8	319.88	3577419.0
2020-07-16 11:00:00	SPY	ETF	319.9	320.3	319.34	319.96	4208488.0
2020-07-16 11:30:00	SPY	ETF	319.97	320.05	319.28	319.8	2401807.0
2020-07-16 12:00:00	SPY	ETF	319.78	320.02	319.24	319.56	2005596.0
2020-07-16 12:30:00	SPY	ETF	319.56	320.1	319.51	319.7	1841511.0
2020-07-16 13:00:00	SPY	ETF	319.69	320.6	319.6234	320.57	1947335.0
2020-07-16 13:30:00	SPY	ETF	320.58	320.6	319.88	319.93	2455913.0
2020-07-16 14:00:00	SPY	ETF	319.93	320.64	319.85	320.49	2217695.0
2020-07-16 14:30:00	SPY	ETF	320.5	320.61	319.25	319.37	3101346.0
2020-07-16 15:00:00	SPY	ETF	319.38	320.86	319.21	320.81	3727790.0
2020-07-16 15:30:00	SPY	ETF	320.8	321.28	320.225	320.81	8764528.0
2020-07-16 16:00:00	SPY	ETF	320.82	320.95	319.45	319.74	3769955.0
2020-07-16 16:30:00	SPY	ETF	319.71	320.79	319.63	319.81	431863.0
2020-07-16 17:00:00	SPY	ETF	319.67	319.83	319.65	319.75	43990.0
2020-07-16 17:30:00	SPY	ETF	319.8	319.85	319.7	319.79	63823.0
2020-07-16 18:00:00	SPY	ETF	319.89	320.09	319.58	319.92	73495.0
2020-07-16 18:30:00	SPY	ETF	319.99	320.32	319.99	320.3	63399.0
2020-07-16 19:00:00	SPY	ETF	320.3	320.47	320.22	320.43	20607.0
2020-07-16 19:30:00	SPY	ETF	320.45	320.45	320.31	320.41	28966.0
2020-07-16 04:00:00	QQQ	ETF	258.22	258.41	257.56	257.66	46936.0
2020-07-16 04:30:00	QQQ	ETF	257.54	257.61	256.88	257.18	65108.0
2020-07-16 05:00:00	QQQ	ETF	257.03	257.03	256.17	256.82	53964.0
2020-07-16 05:30:00	QQQ	ETF	256.78	257.0	256.52	256.6	28337.0
2020-07-16 06:00:00	QQQ	ETF	256.65	257.3	256.59	256.79	80622.0
2020-07-16 06:30:00	QQQ	ETF	256.7	257.06	255.91	256.94	51471.0
2020-07-16 07:00:00	QQQ	ETF	257.12	257.48	256.85	257.41	140663.0
2020-07-16 07:30:00	QQQ	ETF	257.43	257.79	257.29	257.31	136423.0
2020-07-16 08:00:00	QQQ	ETF	257.6	258.94	256.0804	257.72	538399.0
2020-07-16 08:30:00	QQQ	ETF	257.74	257.74	256.66	257.58	240639.0
2020-07-16 09:00:00	QQQ	ETF	257.58	258.18	257.47	257.99	245680.0
2020-07-16 09:30:00	QQQ	ETF	257.97	258.69	257.14	257.58	4523811.0
2020-07-16 10:00:00	QQQ	ETF	257.61	257.75	256.38	257.31	4578092.0
2020-07-16 10:30:00	QQQ	ETF	257.29	257.8999	256.28	256.475	2849482.0
2020-07-16 11:00:00	QQQ	ETF	256.49	256.72	255.62	256.5	3387995.0
2020-07-16 11:30:00	QQQ	ETF	256.47	257.28	256.2512	257.26	1737013.0
2020-07-16 12:00:00	QQQ	ETF	257.28	257.65	256.735	257.02	1403998.0
2020-07-16 12:30:00	QQQ	ETF	257.0105	258.0	256.91	257.65	1196063.0

> showing 50 of 20,107 rows — these rows as CSV

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