PREVIEW / etf_30min / 2019-04-29

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-29.parquet
  size:    489 KB
  rows:    17,101

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
2019-04-29 04:00:00	SPY	ETF	293.56	293.89	293.56	293.85	3010.0
2019-04-29 04:30:00	SPY	ETF	293.74	293.74	293.64	293.69	1870.0
2019-04-29 05:00:00	SPY	ETF	293.4	293.4	293.36	293.36	640.0
2019-04-29 05:30:00	SPY	ETF	293.46	293.46	293.4	293.42	871.0
2019-04-29 06:00:00	SPY	ETF	293.38	293.46	293.35	293.39	3030.0
2019-04-29 06:30:00	SPY	ETF	293.35	293.36	293.17	293.21	12543.0
2019-04-29 07:00:00	SPY	ETF	293.21	293.3	293.06	293.12	20540.0
2019-04-29 07:30:00	SPY	ETF	293.19	293.31	293.19	293.29	7371.0
2019-04-29 08:00:00	SPY	ETF	293.19	293.57	293.14	293.39	21603.0
2019-04-29 08:30:00	SPY	ETF	293.44	293.51	293.22	293.45	113532.0
2019-04-29 09:00:00	SPY	ETF	293.47	293.6	293.37	293.55	130636.0
2019-04-29 09:30:00	SPY	ETF	293.51	294.07	293.48	293.77	4804425.0
2019-04-29 10:00:00	SPY	ETF	293.78	293.85	293.41	293.79	2256176.0
2019-04-29 10:30:00	SPY	ETF	293.79	294.13	293.73	293.91	12770900.0
2019-04-29 11:00:00	SPY	ETF	293.92	294.04	293.71	293.83	2352824.0
2019-04-29 11:30:00	SPY	ETF	293.82	293.91	293.72	293.81	2305306.0
2019-04-29 12:00:00	SPY	ETF	293.815	294.19	293.71	294.18	3285834.0
2019-04-29 12:30:00	SPY	ETF	294.18	294.3	294.105	294.24	2270689.0
2019-04-29 13:00:00	SPY	ETF	294.24	294.25	294.1	294.22	4518583.0
2019-04-29 13:30:00	SPY	ETF	294.23	294.24	294.06	294.2	1223253.0
2019-04-29 14:00:00	SPY	ETF	294.205	294.45	294.19	294.31	3211948.0
2019-04-29 14:30:00	SPY	ETF	294.31	294.32	294.13	294.18	2935603.0
2019-04-29 15:00:00	SPY	ETF	294.19	294.29	294.08	294.115	1218069.0
2019-04-29 15:30:00	SPY	ETF	294.11	294.225	293.76	293.81	5893149.0
2019-04-29 16:00:00	SPY	ETF	293.81	293.87	293.44	293.49	4415332.0
2019-04-29 16:30:00	SPY	ETF	293.49	293.87	293.48	293.58	1421720.0
2019-04-29 17:00:00	SPY	ETF	293.6	294.0154	293.45	293.59	942403.0
2019-04-29 17:30:00	SPY	ETF	293.55	293.61	293.48	293.54	30985.0
2019-04-29 18:00:00	SPY	ETF	293.58	293.59	293.44	293.44	37527.0
2019-04-29 18:30:00	SPY	ETF	293.44	293.56	293.44	293.5	18708.0
2019-04-29 19:00:00	SPY	ETF	293.5	293.53	293.5	293.53	16625.0
2019-04-29 19:30:00	SPY	ETF	293.52	293.53	293.4	293.41	56207.0
2019-04-29 04:00:00	QQQ	ETF	190.89	191.08	190.89	191.04	7738.0
2019-04-29 04:30:00	QQQ	ETF	190.96	190.99	190.89	190.92	14776.0
2019-04-29 05:00:00	QQQ	ETF	190.89	190.93	190.63	190.7	10930.0
2019-04-29 05:30:00	QQQ	ETF	190.64	190.66	190.56	190.64	4597.0
2019-04-29 06:00:00	QQQ	ETF	190.59	190.69	190.59	190.68	2987.0
2019-04-29 06:30:00	QQQ	ETF	190.65	190.65	190.44	190.45	13397.0
2019-04-29 07:00:00	QQQ	ETF	190.44	190.54	190.37	190.49	21800.0
2019-04-29 07:30:00	QQQ	ETF	190.5	190.58	190.46	190.5	11582.0
2019-04-29 08:00:00	QQQ	ETF	190.47	190.98	190.4601	190.64	352170.0
2019-04-29 08:30:00	QQQ	ETF	190.66	190.68	190.39	190.6	125442.0
2019-04-29 09:00:00	QQQ	ETF	190.6	190.74	190.57	190.62	94296.0
2019-04-29 09:30:00	QQQ	ETF	190.62	190.93	190.41	190.6515	2682180.0
2019-04-29 10:00:00	QQQ	ETF	190.665	190.88	190.34	190.81	1444779.0
2019-04-29 10:30:00	QQQ	ETF	190.82	191.109	190.68	190.98	1143334.0
2019-04-29 11:00:00	QQQ	ETF	190.975	191.09	190.77	190.88	746546.0
2019-04-29 11:30:00	QQQ	ETF	190.88	190.9542	190.73	190.76	844246.0
2019-04-29 12:00:00	QQQ	ETF	190.75	190.98	190.69	190.95	694002.0
2019-04-29 12:30:00	QQQ	ETF	190.96	191.18	190.935	191.08	891479.0

> showing 50 of 17,101 rows — these rows as CSV

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