PREVIEW / etf_30min / 2020-11-06

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-06.parquet
  size:    569 KB
  rows:    21,133

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-11-06 04:00:00	SPY	ETF	348.07	348.11	347.0	347.76	93717.0
2020-11-06 04:30:00	SPY	ETF	347.67	347.77	346.12	346.3	56398.0
2020-11-06 05:00:00	SPY	ETF	346.3	347.2	345.77	347.2	28423.0
2020-11-06 05:30:00	SPY	ETF	347.21	347.86	347.08	347.5	53374.0
2020-11-06 06:00:00	SPY	ETF	347.69	348.28	347.69	347.82	34078.0
2020-11-06 06:30:00	SPY	ETF	347.89	348.17	347.4	347.86	68689.0
2020-11-06 07:00:00	SPY	ETF	347.84	348.53	347.36	347.59	128409.0
2020-11-06 07:30:00	SPY	ETF	347.54	347.57	346.78	346.99	241684.0
2020-11-06 08:00:00	SPY	ETF	348.3599	350.0	346.54	347.6	319047.0
2020-11-06 08:30:00	SPY	ETF	347.66	350.3	347.66	350.03	917507.0
2020-11-06 09:00:00	SPY	ETF	350.04	351.87	349.5	349.91	1307836.0
2020-11-06 09:30:00	SPY	ETF	349.93	350.32	347.65	348.26	6252870.0
2020-11-06 10:00:00	SPY	ETF	348.26	350.12	348.04	349.8211	3651978.0
2020-11-06 10:30:00	SPY	ETF	349.81	350.52	348.47	348.8866	3463781.0
2020-11-06 11:00:00	SPY	ETF	348.87	350.6197	348.643	350.08	5425197.0
2020-11-06 11:30:00	SPY	ETF	350.06	350.9	349.84	350.37	2926669.0
2020-11-06 12:00:00	SPY	ETF	350.36	350.78	349.64	349.83	3045655.0
2020-11-06 12:30:00	SPY	ETF	349.8322	350.37	349.4702	350.11	2228504.0
2020-11-06 13:00:00	SPY	ETF	350.127	350.81	350.06	350.69	1860246.0
2020-11-06 13:30:00	SPY	ETF	350.68	350.82	350.33	350.47	1468098.0
2020-11-06 14:00:00	SPY	ETF	350.47	350.78	350.255	350.55	2094609.0
2020-11-06 14:30:00	SPY	ETF	350.54	350.7778	349.77	349.99	2400193.0
2020-11-06 15:00:00	SPY	ETF	349.97	350.3579	349.21	350.01	11298162.0
2020-11-06 15:30:00	SPY	ETF	350.01	351.51	349.82	350.19	13624962.0
2020-11-06 16:00:00	SPY	ETF	350.2	350.75	350.06	350.63	9784519.0
2020-11-06 16:30:00	SPY	ETF	350.62	351.0	350.58	351.0	614224.0
2020-11-06 17:00:00	SPY	ETF	351.06	351.06	350.16	350.95	264831.0
2020-11-06 17:30:00	SPY	ETF	350.99	351.03	350.08	350.91	236292.0
2020-11-06 18:00:00	SPY	ETF	350.91	350.93	350.86	350.86	44874.0
2020-11-06 18:30:00	SPY	ETF	350.86	350.91	350.82	350.9	16178.0
2020-11-06 19:00:00	SPY	ETF	350.9	350.97	350.87	350.92	15301.0
2020-11-06 19:30:00	SPY	ETF	350.92	351.03	350.91	350.96	33123.0
2020-11-06 04:00:00	QQQ	ETF	291.62	291.82	290.86	291.5	50482.0
2020-11-06 04:30:00	QQQ	ETF	291.36	291.5	290.3	290.4	36604.0
2020-11-06 05:00:00	QQQ	ETF	290.43	290.93	289.55	290.93	41438.0
2020-11-06 05:30:00	QQQ	ETF	290.92	291.38	290.6	291.14	36621.0
2020-11-06 06:00:00	QQQ	ETF	291.18	291.87	291.18	291.52	62346.0
2020-11-06 06:30:00	QQQ	ETF	291.59	291.95	291.2	291.5	41998.0
2020-11-06 07:00:00	QQQ	ETF	291.55	292.38	291.3	291.6	129237.0
2020-11-06 07:30:00	QQQ	ETF	291.62	291.62	290.8	291.2	174156.0
2020-11-06 08:00:00	QQQ	ETF	291.17	293.11	290.73	291.51	314269.0
2020-11-06 08:30:00	QQQ	ETF	291.55	293.25	291.55	293.22	382998.0
2020-11-06 09:00:00	QQQ	ETF	293.25	294.42	292.64	293.56	948494.0
2020-11-06 09:30:00	QQQ	ETF	293.55	293.91	289.83	290.2	5574150.0
2020-11-06 10:00:00	QQQ	ETF	290.22	292.76	289.95	292.5587	2807849.0
2020-11-06 10:30:00	QQQ	ETF	292.52	293.25	291.69	291.99	2050516.0
2020-11-06 11:00:00	QQQ	ETF	291.99	293.6	291.76	293.5	1677272.0
2020-11-06 11:30:00	QQQ	ETF	293.46	294.36	293.22	293.87	1660829.0
2020-11-06 12:00:00	QQQ	ETF	293.9	294.55	293.35	293.55	1496753.0
2020-11-06 12:30:00	QQQ	ETF	293.54	294.31	293.39	294.25	1026813.0

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

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