PREVIEW / etf_30min / 2018-02-16

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-16.parquet
  size:    487 KB
  rows:    16,782

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-02-16 04:00:00	SPY	ETF	274.03	274.4	274.03	274.4	12159.0
2018-02-16 04:30:00	SPY	ETF	274.37	274.53	274.25	274.3	32345.0
2018-02-16 05:00:00	SPY	ETF	274.3	274.52	274.3	274.32	19220.0
2018-02-16 05:30:00	SPY	ETF	274.25	274.25	273.75	273.94	19794.0
2018-02-16 06:00:00	SPY	ETF	273.9	274.06	273.79	273.92	5860.0
2018-02-16 06:30:00	SPY	ETF	273.82	273.89	273.54	273.8	16475.0
2018-02-16 07:00:00	SPY	ETF	273.74	273.97	273.61	273.82	104056.0
2018-02-16 07:30:00	SPY	ETF	273.79	274.05	273.79	273.92	123222.0
2018-02-16 08:00:00	SPY	ETF	273.91	273.95	273.18	273.34	211135.0
2018-02-16 08:30:00	SPY	ETF	273.33	273.6	272.98	273.05	390059.0
2018-02-16 09:00:00	SPY	ETF	273.04	273.07	272.13	272.33	1785386.0
2018-02-16 09:30:00	SPY	ETF	272.32	273.46	272.27	272.76	11042735.0
2018-02-16 10:00:00	SPY	ETF	272.78	273.62	272.45	273.61	21029368.0
2018-02-16 10:30:00	SPY	ETF	273.61	274.025	273.44	273.53	10852821.0
2018-02-16 11:00:00	SPY	ETF	273.52	274.5	273.52	274.01	5477998.0
2018-02-16 11:30:00	SPY	ETF	274.01	274.69	274.005	274.57	3316898.0
2018-02-16 12:00:00	SPY	ETF	274.565	274.77	274.42	274.7	4092259.0
2018-02-16 12:30:00	SPY	ETF	274.71	275.32	274.01	274.49	8797654.0
2018-02-16 13:00:00	SPY	ETF	274.51	274.78	273.34	273.49	8426076.0
2018-02-16 13:30:00	SPY	ETF	273.49	274.28	272.905	273.66	7549970.0
2018-02-16 14:00:00	SPY	ETF	273.67	274.07	272.5	273.175	7696311.0
2018-02-16 14:30:00	SPY	ETF	273.18	273.84	272.85	273.84	10797154.0
2018-02-16 15:00:00	SPY	ETF	273.835	274.21	273.5601	273.85	12690400.0
2018-02-16 15:30:00	SPY	ETF	273.85	274.095	273.02	273.09	14516019.0
2018-02-16 16:00:00	SPY	ETF	273.12	274.13	273.0	273.35	21061127.0
2018-02-16 16:30:00	SPY	ETF	273.36	273.9	273.31	273.51	1269065.0
2018-02-16 17:00:00	SPY	ETF	273.53	273.8	273.11	273.41	4844897.0
2018-02-16 17:30:00	SPY	ETF	273.41	273.45	273.35	273.45	25174.0
2018-02-16 18:00:00	SPY	ETF	273.45	273.45	273.15	273.15	18593.0
2018-02-16 18:30:00	SPY	ETF	273.15	273.15	273.05	273.12	27880.0
2018-02-16 19:00:00	SPY	ETF	273.13	273.25	273.12	273.25	4348.0
2018-02-16 19:30:00	SPY	ETF	273.3	273.34	273.2	273.34	6971.0
2018-02-16 04:00:00	QQQ	ETF	166.68	166.91	166.68	166.87	6771.0
2018-02-16 04:30:00	QQQ	ETF	166.93	167.05	166.74	166.74	15616.0
2018-02-16 05:00:00	QQQ	ETF	166.81	166.96	166.73	166.75	10594.0
2018-02-16 05:30:00	QQQ	ETF	166.72	166.75	166.42	166.5	45896.0
2018-02-16 06:00:00	QQQ	ETF	166.48	166.59	166.42	166.51	20675.0
2018-02-16 06:30:00	QQQ	ETF	166.4	166.48	166.25	166.4	32705.0
2018-02-16 07:00:00	QQQ	ETF	166.38	166.54	166.26	166.39	42326.0
2018-02-16 07:30:00	QQQ	ETF	166.41	166.53	166.37	166.44	41391.0
2018-02-16 08:00:00	QQQ	ETF	166.4	166.92	165.82	165.92	296950.0
2018-02-16 08:30:00	QQQ	ETF	165.94	166.09	165.62	165.64	183721.0
2018-02-16 09:00:00	QQQ	ETF	165.61	165.64	165.07	165.21	607405.0
2018-02-16 09:30:00	QQQ	ETF	165.2	166.25	165.16	165.74	4594516.0
2018-02-16 10:00:00	QQQ	ETF	165.77	166.16	165.3015	166.15	4517943.0
2018-02-16 10:30:00	QQQ	ETF	166.15	166.42	165.9	165.95	2245507.0
2018-02-16 11:00:00	QQQ	ETF	165.9634	166.43	165.85	166.1	1798910.0
2018-02-16 11:30:00	QQQ	ETF	166.09	166.47	166.04	166.37	1564868.0
2018-02-16 12:00:00	QQQ	ETF	166.37	166.53	166.22	166.51	1191258.0
2018-02-16 12:30:00	QQQ	ETF	166.505	166.755	165.89	166.24	3651957.0

> showing 50 of 16,782 rows — these rows as CSV

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