PREVIEW / etf_30min / 2020-10-09

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-09.parquet
  size:    563 KB
  rows:    20,769

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-10-09 04:00:00	SPY	ETF	345.0	345.14	344.9	345.0	14984.0
2020-10-09 04:30:00	SPY	ETF	345.0	345.3	344.85	345.04	40626.0
2020-10-09 05:00:00	SPY	ETF	345.01	345.05	344.87	345.04	15185.0
2020-10-09 05:30:00	SPY	ETF	345.05	345.13	344.95	345.08	8544.0
2020-10-09 06:00:00	SPY	ETF	345.06	345.53	345.05	345.2	20117.0
2020-10-09 06:30:00	SPY	ETF	345.25	345.29	344.69	344.72	24214.0
2020-10-09 07:00:00	SPY	ETF	344.7	345.35	344.65	345.3	78045.0
2020-10-09 07:30:00	SPY	ETF	345.35	345.45	345.19	345.23	48013.0
2020-10-09 08:00:00	SPY	ETF	345.21	345.96	343.78	345.34	280437.0
2020-10-09 08:30:00	SPY	ETF	345.35	345.9	345.28	345.74	219064.0
2020-10-09 09:00:00	SPY	ETF	345.79	345.92	345.54	345.6	151218.0
2020-10-09 09:30:00	SPY	ETF	345.56	346.1	345.11	345.55	5115745.0
2020-10-09 10:00:00	SPY	ETF	345.545	345.7	344.89	345.0	3352733.0
2020-10-09 10:30:00	SPY	ETF	345.0	345.67	344.98	345.56	2652321.0
2020-10-09 11:00:00	SPY	ETF	345.57	346.05	345.56	345.91	2478700.0
2020-10-09 11:30:00	SPY	ETF	345.92	347.19	345.838	346.97	5832496.0
2020-10-09 12:00:00	SPY	ETF	346.96	347.35	346.51	346.765	4371875.0
2020-10-09 12:30:00	SPY	ETF	346.77	347.12	346.5236	346.67	4774229.0
2020-10-09 13:00:00	SPY	ETF	346.68	346.88	346.39	346.505	1571718.0
2020-10-09 13:30:00	SPY	ETF	346.51	346.92	346.4	346.91	1402095.0
2020-10-09 14:00:00	SPY	ETF	346.92	346.92	346.22	346.3646	2432723.0
2020-10-09 14:30:00	SPY	ETF	346.37	346.68	345.95	346.36	2888165.0
2020-10-09 15:00:00	SPY	ETF	346.343	346.99	346.21	346.9	3543839.0
2020-10-09 15:30:00	SPY	ETF	346.89	346.91	346.12	346.84	9495180.0
2020-10-09 16:00:00	SPY	ETF	346.83	347.33	346.69	347.32	7095114.0
2020-10-09 16:30:00	SPY	ETF	347.32	347.88	346.85	347.56	613363.0
2020-10-09 17:00:00	SPY	ETF	347.53	347.6	346.85	347.29	78290.0
2020-10-09 17:30:00	SPY	ETF	347.27	347.29	347.15	347.26	26883.0
2020-10-09 18:00:00	SPY	ETF	347.27	347.27	347.15	347.2	16274.0
2020-10-09 18:30:00	SPY	ETF	347.21	347.25	347.16	347.22	33792.0
2020-10-09 19:00:00	SPY	ETF	347.22	347.24	347.16	347.17	8659.0
2020-10-09 19:30:00	SPY	ETF	347.2	347.27	347.15	347.25	26059.0
2020-10-09 04:00:00	QQQ	ETF	282.18	282.39	282.1	282.26	12088.0
2020-10-09 04:30:00	QQQ	ETF	282.25	282.6	282.19	282.46	21600.0
2020-10-09 05:00:00	QQQ	ETF	282.46	282.5	282.35	282.4	13600.0
2020-10-09 05:30:00	QQQ	ETF	282.41	282.42	282.28	282.29	8800.0
2020-10-09 06:00:00	QQQ	ETF	282.24	282.58	282.15	282.3	5700.0
2020-10-09 06:30:00	QQQ	ETF	282.4	282.4	281.91	281.96	14902.0
2020-10-09 07:00:00	QQQ	ETF	281.97	282.59	281.97	282.52	58627.0
2020-10-09 07:30:00	QQQ	ETF	282.55	282.72	282.54	282.64	32637.0
2020-10-09 08:00:00	QQQ	ETF	282.3699	282.98	281.95	282.75	122247.0
2020-10-09 08:30:00	QQQ	ETF	282.73	283.41	282.7	283.3	115892.0
2020-10-09 09:00:00	QQQ	ETF	283.26	283.39	283.06	283.08	91239.0
2020-10-09 09:30:00	QQQ	ETF	283.05	283.95	282.71	283.79	2552703.0
2020-10-09 10:00:00	QQQ	ETF	283.8	284.1	283.33	283.75	1843082.0
2020-10-09 10:30:00	QQQ	ETF	283.745	284.46	283.73	284.3	1413175.0
2020-10-09 11:00:00	QQQ	ETF	284.31	284.64	284.2	284.51	1260136.0
2020-10-09 11:30:00	QQQ	ETF	284.5118	285.13	284.43	284.9	2281916.0
2020-10-09 12:00:00	QQQ	ETF	284.89	285.39	284.53	284.82	1656477.0
2020-10-09 12:30:00	QQQ	ETF	284.81	285.3	284.81	285.12	1117327.0

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

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