PREVIEW / etf_30min / 2020-07-06

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-06.parquet
  size:    563 KB
  rows:    21,341

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-06 04:00:00	SPY	ETF	316.61	317.13	316.59	317.0	30441.0
2020-07-06 04:30:00	SPY	ETF	317.0	317.0	316.44	316.49	35791.0
2020-07-06 05:00:00	SPY	ETF	316.44	316.54	315.87	316.3	30915.0
2020-07-06 05:30:00	SPY	ETF	316.36	316.61	316.3	316.54	51919.0
2020-07-06 06:00:00	SPY	ETF	316.67	317.27	316.67	316.94	113979.0
2020-07-06 06:30:00	SPY	ETF	316.96	316.96	316.47	316.63	72637.0
2020-07-06 07:00:00	SPY	ETF	316.63	316.63	316.32	316.54	146041.0
2020-07-06 07:30:00	SPY	ETF	316.57	316.86	316.27	316.77	198197.0
2020-07-06 08:00:00	SPY	ETF	316.5499	317.05	316.1	317.01	349379.0
2020-07-06 08:30:00	SPY	ETF	317.01	317.13	316.8	317.08	357273.0
2020-07-06 09:00:00	SPY	ETF	317.04	317.08	316.38	316.38	279463.0
2020-07-06 09:30:00	SPY	ETF	316.37	316.88	315.87	316.72	6114296.0
2020-07-06 10:00:00	SPY	ETF	317.07	317.68	315.56	315.97	6824725.0
2020-07-06 10:30:00	SPY	ETF	315.95	316.95	315.69	316.9	3570870.0
2020-07-06 11:00:00	SPY	ETF	316.93	317.16	316.7	317.14	3386647.0
2020-07-06 11:30:00	SPY	ETF	317.135	317.23	316.44	316.445	3135238.0
2020-07-06 12:00:00	SPY	ETF	316.445	316.58	316.0	316.255	2953962.0
2020-07-06 12:30:00	SPY	ETF	316.25	316.58	316.09	316.48	1472885.0
2020-07-06 13:00:00	SPY	ETF	316.485	316.5615	316.02	316.56	1956393.0
2020-07-06 13:30:00	SPY	ETF	316.56	316.68	316.345	316.629	1975130.0
2020-07-06 14:00:00	SPY	ETF	316.62	316.635	315.56	315.97	3695293.0
2020-07-06 14:30:00	SPY	ETF	315.97	316.38	315.71	315.99	2731227.0
2020-07-06 15:00:00	SPY	ETF	315.98	316.27	315.63	316.22	3659058.0
2020-07-06 15:30:00	SPY	ETF	316.23	317.24	315.86	316.99	10362731.0
2020-07-06 16:00:00	SPY	ETF	316.98	317.41	316.76	317.1	5804082.0
2020-07-06 16:30:00	SPY	ETF	317.15	317.28	316.95	316.95	484013.0
2020-07-06 17:00:00	SPY	ETF	316.98	317.06	316.86	317.02	76206.0
2020-07-06 17:30:00	SPY	ETF	316.99	317.05	316.97	317.03	19827.0
2020-07-06 18:00:00	SPY	ETF	317.03	317.1	316.77	316.86	69142.0
2020-07-06 18:30:00	SPY	ETF	316.89	317.4	316.81	317.26	44310.0
2020-07-06 19:00:00	SPY	ETF	317.27	317.7	317.25	317.62	309666.0
2020-07-06 19:30:00	SPY	ETF	317.65	317.91	317.63	317.73	135101.0
2020-07-06 04:00:00	QQQ	ETF	255.45	255.98	255.45	255.86	22739.0
2020-07-06 04:30:00	QQQ	ETF	255.89	255.89	255.66	255.69	36697.0
2020-07-06 05:00:00	QQQ	ETF	255.63	255.72	255.35	255.46	14445.0
2020-07-06 05:30:00	QQQ	ETF	255.44	255.69	255.42	255.68	20214.0
2020-07-06 06:00:00	QQQ	ETF	255.6	255.92	255.6	255.78	53075.0
2020-07-06 06:30:00	QQQ	ETF	255.78	255.78	255.47	255.63	11978.0
2020-07-06 07:00:00	QQQ	ETF	255.62	255.75	255.5	255.73	62202.0
2020-07-06 07:30:00	QQQ	ETF	255.74	255.74	255.55	255.68	122185.0
2020-07-06 08:00:00	QQQ	ETF	255.54	256.07	255.49	255.83	72043.0
2020-07-06 08:30:00	QQQ	ETF	255.84	255.94	255.74	255.89	78399.0
2020-07-06 09:00:00	QQQ	ETF	255.88	255.9	255.35	255.44	100062.0
2020-07-06 09:30:00	QQQ	ETF	255.42	256.64	255.42	256.6001	3315526.0
2020-07-06 10:00:00	QQQ	ETF	256.61	257.18	256.39	256.97	3412683.0
2020-07-06 10:30:00	QQQ	ETF	256.95	257.95	256.78	257.939	1501804.0
2020-07-06 11:00:00	QQQ	ETF	257.94	258.76	257.87	258.7	1784137.0
2020-07-06 11:30:00	QQQ	ETF	258.71	258.928	258.29	258.34	1501188.0
2020-07-06 12:00:00	QQQ	ETF	258.347	258.44	257.54	257.78	1633621.0
2020-07-06 12:30:00	QQQ	ETF	257.77	258.35	257.57	258.16	1037318.0

> showing 50 of 21,341 rows — these rows as CSV

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