PREVIEW / etf_30min / 2019-02-14

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-14.parquet
  size:    493 KB
  rows:    17,365

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-02-14 04:00:00	SPY	ETF	275.45	275.75	275.38	275.75	18042.0
2019-02-14 04:30:00	SPY	ETF	275.75	275.75	275.48	275.5	5588.0
2019-02-14 05:00:00	SPY	ETF	275.55	275.63	275.34	275.34	5260.0
2019-02-14 05:30:00	SPY	ETF	275.39	275.44	275.25	275.44	9900.0
2019-02-14 06:00:00	SPY	ETF	275.5	275.7	275.5	275.61	13175.0
2019-02-14 06:30:00	SPY	ETF	275.65	275.68	275.56	275.56	33033.0
2019-02-14 07:00:00	SPY	ETF	275.55	275.65	275.42	275.65	108333.0
2019-02-14 07:30:00	SPY	ETF	275.66	275.82	275.65	275.73	76880.0
2019-02-14 08:00:00	SPY	ETF	275.35	275.95	275.1	275.74	186827.0
2019-02-14 08:30:00	SPY	ETF	275.74	275.74	273.95	274.01	1454543.0
2019-02-14 09:00:00	SPY	ETF	274.05	274.05	273.5	273.75	1059004.0
2019-02-14 09:30:00	SPY	ETF	273.78	273.83	272.87	273.79	11758493.0
2019-02-14 10:00:00	SPY	ETF	273.78	274.35	273.48	274.32	7267103.0
2019-02-14 10:30:00	SPY	ETF	274.3	274.67	273.39	274.01	11607586.0
2019-02-14 11:00:00	SPY	ETF	274.0064	274.15	273.53	273.78	3540743.0
2019-02-14 11:30:00	SPY	ETF	273.8	274.41	273.48	274.34	3344787.0
2019-02-14 12:00:00	SPY	ETF	274.34	275.35	274.2	275.19	5716285.0
2019-02-14 12:30:00	SPY	ETF	275.18	275.25	275.0	275.085	1980417.0
2019-02-14 13:00:00	SPY	ETF	275.1	275.22	274.84	275.0754	2572939.0
2019-02-14 13:30:00	SPY	ETF	275.075	275.2	274.86	274.98	2498019.0
2019-02-14 14:00:00	SPY	ETF	274.99	275.29	274.81	275.15	3929390.0
2019-02-14 14:30:00	SPY	ETF	275.15	275.26	274.67	274.832	4265520.0
2019-02-14 15:00:00	SPY	ETF	274.85	275.64	274.64	274.858	6048662.0
2019-02-14 15:30:00	SPY	ETF	274.86	275.2884	274.29	274.38	9922879.0
2019-02-14 16:00:00	SPY	ETF	274.4	274.52	274.11	274.31	3587600.0
2019-02-14 16:30:00	SPY	ETF	274.32	274.38	274.0	274.0	171989.0
2019-02-14 17:00:00	SPY	ETF	273.99	274.3754	273.98	274.0	363793.0
2019-02-14 17:30:00	SPY	ETF	274.01	274.13	273.97	274.03	204103.0
2019-02-14 18:00:00	SPY	ETF	274.0	274.18	273.82	274.15	412104.0
2019-02-14 18:30:00	SPY	ETF	274.15	274.3772	274.02	274.1	177433.0
2019-02-14 19:00:00	SPY	ETF	274.08	274.1	273.6	273.85	88063.0
2019-02-14 19:30:00	SPY	ETF	273.8	273.81	273.47	273.6	55550.0
2019-02-14 04:00:00	QQQ	ETF	171.45	171.69	171.45	171.67	8916.0
2019-02-14 04:30:00	QQQ	ETF	171.7	171.71	171.57	171.57	12514.0
2019-02-14 05:00:00	QQQ	ETF	171.61	171.65	171.44	171.44	8400.0
2019-02-14 05:30:00	QQQ	ETF	171.49	171.53	171.37	171.45	10896.0
2019-02-14 06:00:00	QQQ	ETF	171.53	171.65	171.53	171.62	6300.0
2019-02-14 06:30:00	QQQ	ETF	171.57	171.62	171.53	171.53	3750.0
2019-02-14 07:00:00	QQQ	ETF	171.55	171.68	171.51	171.65	26374.0
2019-02-14 07:30:00	QQQ	ETF	171.67	171.73	171.63	171.64	73592.0
2019-02-14 08:00:00	QQQ	ETF	171.52	171.84	171.3	171.8	90894.0
2019-02-14 08:30:00	QQQ	ETF	171.7	171.7	170.46	170.52	454833.0
2019-02-14 09:00:00	QQQ	ETF	170.54	170.54	170.15	170.36	422520.0
2019-02-14 09:30:00	QQQ	ETF	170.38	170.76	169.83	170.72	4360149.0
2019-02-14 10:00:00	QQQ	ETF	170.71	171.08	170.49	171.03	2796070.0
2019-02-14 10:30:00	QQQ	ETF	171.02	171.23	170.25	170.74	3743409.0
2019-02-14 11:00:00	QQQ	ETF	170.75	170.84	170.43	170.62	1107607.0
2019-02-14 11:30:00	QQQ	ETF	170.62	171.09	170.36	170.99	1304185.0
2019-02-14 12:00:00	QQQ	ETF	170.99	171.73	170.87	171.63	2110746.0
2019-02-14 12:30:00	QQQ	ETF	171.64	171.7	171.4701	171.59	712162.0

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

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