PREVIEW / etf_30min / 2020-08-04

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-04.parquet
  size:    553 KB
  rows:    20,662

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-08-04 04:00:00	SPY	ETF	328.11	328.22	327.52	328.22	40081.0
2020-08-04 04:30:00	SPY	ETF	328.26	328.35	327.77	328.15	12451.0
2020-08-04 05:00:00	SPY	ETF	328.04	328.41	327.99	328.0	20850.0
2020-08-04 05:30:00	SPY	ETF	328.0	328.28	327.8	328.17	17235.0
2020-08-04 06:00:00	SPY	ETF	328.18	328.24	327.82	328.0	23216.0
2020-08-04 06:30:00	SPY	ETF	327.95	328.1	327.86	328.1	34518.0
2020-08-04 07:00:00	SPY	ETF	328.06	328.35	327.76	327.87	85043.0
2020-08-04 07:30:00	SPY	ETF	327.79	327.79	327.25	327.45	232852.0
2020-08-04 08:00:00	SPY	ETF	327.4	329.5	327.15	327.62	206547.0
2020-08-04 08:30:00	SPY	ETF	327.6	327.75	327.32	327.56	131104.0
2020-08-04 09:00:00	SPY	ETF	327.49	327.98	327.36	327.85	229868.0
2020-08-04 09:30:00	SPY	ETF	327.86	328.77	327.86	328.65	4214668.0
2020-08-04 10:00:00	SPY	ETF	328.64	329.34	328.55	328.81	3071443.0
2020-08-04 10:30:00	SPY	ETF	328.8199	329.64	328.61	329.3744	2695847.0
2020-08-04 11:00:00	SPY	ETF	329.38	329.64	329.15	329.4	2393220.0
2020-08-04 11:30:00	SPY	ETF	329.42	329.66	329.272	329.43	2974531.0
2020-08-04 12:00:00	SPY	ETF	329.4276	329.52	328.82	329.135	2202661.0
2020-08-04 12:30:00	SPY	ETF	329.14	329.24	328.75	328.93	2811730.0
2020-08-04 13:00:00	SPY	ETF	328.92	329.42	328.64	329.28	1404265.0
2020-08-04 13:30:00	SPY	ETF	329.275	329.39	329.04	329.335	1171469.0
2020-08-04 14:00:00	SPY	ETF	329.34	329.46	328.65	328.67	1800751.0
2020-08-04 14:30:00	SPY	ETF	328.67	329.045	327.95	328.99	4046703.0
2020-08-04 15:00:00	SPY	ETF	328.99	329.32	328.86	329.11	2772207.0
2020-08-04 15:30:00	SPY	ETF	329.11	330.06	328.82	330.02	6000035.0
2020-08-04 16:00:00	SPY	ETF	330.01	330.07	329.8	329.93	2061531.0
2020-08-04 16:30:00	SPY	ETF	329.92	330.07	329.69	329.97	298796.0
2020-08-04 17:00:00	SPY	ETF	329.99	330.0	329.74	330.0	55059.0
2020-08-04 17:30:00	SPY	ETF	329.99	330.1	329.96	330.09	50660.0
2020-08-04 18:00:00	SPY	ETF	330.0	330.1	329.85	329.96	41728.0
2020-08-04 18:30:00	SPY	ETF	329.98	330.08	329.97	330.03	74161.0
2020-08-04 19:00:00	SPY	ETF	330.03	330.07	329.98	330.0699	105181.0
2020-08-04 19:30:00	SPY	ETF	330.06	330.08	329.98	330.0	20991.0
2020-08-04 04:00:00	QQQ	ETF	268.77	268.9	268.25	268.75	35979.0
2020-08-04 04:30:00	QQQ	ETF	268.76	268.84	268.09	268.56	11512.0
2020-08-04 05:00:00	QQQ	ETF	268.59	268.82	268.44	268.57	22989.0
2020-08-04 05:30:00	QQQ	ETF	268.47	268.7	268.46	268.58	9590.0
2020-08-04 06:00:00	QQQ	ETF	268.59	268.66	268.33	268.5	45052.0
2020-08-04 06:30:00	QQQ	ETF	268.49	268.73	268.49	268.67	24260.0
2020-08-04 07:00:00	QQQ	ETF	268.68	269.06	268.35	268.51	144666.0
2020-08-04 07:30:00	QQQ	ETF	268.51	268.51	268.22	268.3	197238.0
2020-08-04 08:00:00	QQQ	ETF	268.4	270.32	268.12	268.5	125762.0
2020-08-04 08:30:00	QQQ	ETF	268.46	268.49	267.98	268.49	173874.0
2020-08-04 09:00:00	QQQ	ETF	268.4899	268.89	268.35	268.76	236589.0
2020-08-04 09:30:00	QQQ	ETF	268.76	269.99	268.51	269.85	2921249.0
2020-08-04 10:00:00	QQQ	ETF	269.86	270.38	269.6699	269.74	2008439.0
2020-08-04 10:30:00	QQQ	ETF	269.76	270.12	269.535	269.58	1613019.0
2020-08-04 11:00:00	QQQ	ETF	269.61	269.79	268.8	269.1	1865234.0
2020-08-04 11:30:00	QQQ	ETF	269.09	269.51	268.95	269.43	1215086.0
2020-08-04 12:00:00	QQQ	ETF	269.455	269.525	268.58	269.19	1268643.0
2020-08-04 12:30:00	QQQ	ETF	269.19	269.34	268.78	269.05	667372.0

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

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