PREVIEW / etf_30min / 2018-03-20

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-20.parquet
  size:    449 KB
  rows:    15,573

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
2018-03-20 04:00:00	SPY	ETF	271.21	271.26	271.16	271.16	3500.0
2018-03-20 04:30:00	SPY	ETF	271.13	271.26	270.97	271.26	45900.0
2018-03-20 05:00:00	SPY	ETF	271.21	271.21	270.61	270.68	38415.0
2018-03-20 05:30:00	SPY	ETF	270.65	270.92	270.65	270.87	14660.0
2018-03-20 06:00:00	SPY	ETF	270.77	271.18	270.76	271.04	19150.0
2018-03-20 06:30:00	SPY	ETF	271.04	271.47	271.04	271.39	19005.0
2018-03-20 07:00:00	SPY	ETF	271.38	271.62	271.33	271.6	49320.0
2018-03-20 07:30:00	SPY	ETF	271.61	271.78	271.61	271.78	146672.0
2018-03-20 08:00:00	SPY	ETF	271.45	271.84	271.39	271.5	590662.0
2018-03-20 08:30:00	SPY	ETF	271.48	271.5	271.3	271.36	143680.0
2018-03-20 09:00:00	SPY	ETF	271.34	271.36	270.83	270.95	471494.0
2018-03-20 09:30:00	SPY	ETF	270.94	271.67	270.865	270.95	5439214.0
2018-03-20 10:00:00	SPY	ETF	270.9401	271.38	270.54	271.33	4115383.0
2018-03-20 10:30:00	SPY	ETF	271.33	271.66	270.88	271.27	3176381.0
2018-03-20 11:00:00	SPY	ETF	271.29	271.39	270.79	271.11	2251074.0
2018-03-20 11:30:00	SPY	ETF	271.115	271.17	270.23	270.63	2804154.0
2018-03-20 12:00:00	SPY	ETF	270.655	271.22	270.47	271.03	2217656.0
2018-03-20 12:30:00	SPY	ETF	271.02	271.23	270.67	270.8	3377645.0
2018-03-20 13:00:00	SPY	ETF	270.8	270.95	270.46	270.58	4640230.0
2018-03-20 13:30:00	SPY	ETF	270.58	270.9368	270.24	270.3899	5004225.0
2018-03-20 14:00:00	SPY	ETF	270.39	270.96	270.18	270.931	1897426.0
2018-03-20 14:30:00	SPY	ETF	270.94	271.35	270.84	271.26	3330905.0
2018-03-20 15:00:00	SPY	ETF	271.24	271.58	271.11	271.15	4498606.0
2018-03-20 15:30:00	SPY	ETF	271.15	271.28	270.78	270.94	8122070.0
2018-03-20 16:00:00	SPY	ETF	270.93	271.35	270.86	271.29	5626774.0
2018-03-20 16:30:00	SPY	ETF	271.34	271.35	271.1803	271.25	130884.0
2018-03-20 17:00:00	SPY	ETF	271.22	271.25	270.95	271.06	377867.0
2018-03-20 17:30:00	SPY	ETF	271.11	271.24	271.09	271.21	27853.0
2018-03-20 18:00:00	SPY	ETF	271.22	271.39	271.22	271.37	83552.0
2018-03-20 18:30:00	SPY	ETF	271.3	271.3	271.0	271.02	58986.0
2018-03-20 19:00:00	SPY	ETF	271.02	271.22	271.02	271.2	81565.0
2018-03-20 19:30:00	SPY	ETF	271.2	271.23	271.1	271.17	70990.0
2018-03-20 04:00:00	QQQ	ETF	167.41	167.48	167.31	167.4	49100.0
2018-03-20 04:30:00	QQQ	ETF	167.32	167.47	167.3	167.43	13600.0
2018-03-20 05:00:00	QQQ	ETF	167.42	167.42	166.95	166.96	38264.0
2018-03-20 05:30:00	QQQ	ETF	167.0	167.2	167.0	167.15	12540.0
2018-03-20 06:00:00	QQQ	ETF	167.17	167.5	167.17	167.34	15750.0
2018-03-20 06:30:00	QQQ	ETF	167.39	167.7	167.37	167.7	9599.0
2018-03-20 07:00:00	QQQ	ETF	167.65	168.1	167.65	168.1	106366.0
2018-03-20 07:30:00	QQQ	ETF	168.12	168.2	168.03	168.12	99913.0
2018-03-20 08:00:00	QQQ	ETF	168.1	168.14	167.74	167.88	169556.0
2018-03-20 08:30:00	QQQ	ETF	167.87	167.9	167.75	167.81	156175.0
2018-03-20 09:00:00	QQQ	ETF	167.82	167.82	167.0	167.09	482098.0
2018-03-20 09:30:00	QQQ	ETF	167.1	167.97	167.1	167.43	5014303.0
2018-03-20 10:00:00	QQQ	ETF	167.45	167.7	166.95	167.6225	3062479.0
2018-03-20 10:30:00	QQQ	ETF	167.62	167.92	167.4393	167.75	1951408.0
2018-03-20 11:00:00	QQQ	ETF	167.76	167.8498	167.26	167.43	1465993.0
2018-03-20 11:30:00	QQQ	ETF	167.45	167.47	166.61	166.985	2153547.0
2018-03-20 12:00:00	QQQ	ETF	166.99	167.7201	166.84	167.62	1526663.0
2018-03-20 12:30:00	QQQ	ETF	167.61	167.833	167.32	167.4115	1216997.0

> showing 50 of 15,573 rows — these rows as CSV

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