PREVIEW / etf_30min / 2018-11-02

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-02.parquet
  size:    499 KB
  rows:    17,380

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-11-02 04:00:00	SPY	ETF	275.5	276.0	275.41	275.89	127290.0
2018-11-02 04:30:00	SPY	ETF	275.87	275.92	275.45	275.55	53285.0
2018-11-02 05:00:00	SPY	ETF	275.5	275.5	275.25	275.29	25350.0
2018-11-02 05:30:00	SPY	ETF	275.39	275.6	275.08	275.14	30684.0
2018-11-02 06:00:00	SPY	ETF	275.11	275.52	275.01	275.5	53574.0
2018-11-02 06:30:00	SPY	ETF	275.46	275.61	275.3	275.51	87348.0
2018-11-02 07:00:00	SPY	ETF	275.46	276.06	275.33	276.06	244259.0
2018-11-02 07:30:00	SPY	ETF	276.03	276.19	275.85	275.95	282961.0
2018-11-02 08:00:00	SPY	ETF	275.54	276.11	273.42	275.3	1449883.0
2018-11-02 08:30:00	SPY	ETF	275.3	275.53	274.7	275.15	1101417.0
2018-11-02 09:00:00	SPY	ETF	275.17	275.32	274.08	274.74	812813.0
2018-11-02 09:30:00	SPY	ETF	274.75	275.23	274.2097	274.41	9473562.0
2018-11-02 10:00:00	SPY	ETF	274.39	274.48	273.01	273.02	8852349.0
2018-11-02 10:30:00	SPY	ETF	273.02	273.22	271.79	272.87	10711714.0
2018-11-02 11:00:00	SPY	ETF	272.88	272.94	271.35	271.84	8126360.0
2018-11-02 11:30:00	SPY	ETF	271.84	273.73	271.16	271.9399	5455095.0
2018-11-02 12:00:00	SPY	ETF	271.93	273.8143	271.21	271.66	5112859.0
2018-11-02 12:30:00	SPY	ETF	271.64	271.76	269.78	270.2075	6979524.0
2018-11-02 13:00:00	SPY	ETF	270.195	271.07	269.59	270.8144	6604689.0
2018-11-02 13:30:00	SPY	ETF	270.82	271.3798	270.5	270.91	4930403.0
2018-11-02 14:00:00	SPY	ETF	270.92	272.47	270.03	272.18	7193130.0
2018-11-02 14:30:00	SPY	ETF	272.19	272.9801	271.13	271.53	10104656.0
2018-11-02 15:00:00	SPY	ETF	271.53	272.14	270.81	271.72	8148958.0
2018-11-02 15:30:00	SPY	ETF	271.72	272.1	271.2003	271.8	12220543.0
2018-11-02 16:00:00	SPY	ETF	271.84	272.14	271.4684	272.01	11769251.0
2018-11-02 16:30:00	SPY	ETF	272.0	272.04	271.83	271.9	731795.0
2018-11-02 17:00:00	SPY	ETF	271.9	272.05	271.89	271.92	88952.0
2018-11-02 17:30:00	SPY	ETF	271.92	271.93	271.62	271.77	156832.0
2018-11-02 18:00:00	SPY	ETF	271.77	271.89	271.71	271.82	14714.0
2018-11-02 18:30:00	SPY	ETF	271.82	271.93	271.75	271.75	21684.0
2018-11-02 19:00:00	SPY	ETF	271.74	271.82	271.7	271.82	7015.0
2018-11-02 19:30:00	SPY	ETF	271.79	271.84	271.79	271.82	5076.0
2018-11-02 04:00:00	QQQ	ETF	172.75	173.39	172.75	173.33	99671.0
2018-11-02 04:30:00	QQQ	ETF	173.25	173.3	172.69	172.82	78382.0
2018-11-02 05:00:00	QQQ	ETF	172.76	172.76	172.37	172.43	48783.0
2018-11-02 05:30:00	QQQ	ETF	172.48	172.63	172.32	172.46	34223.0
2018-11-02 06:00:00	QQQ	ETF	172.36	172.62	172.32	172.6	66209.0
2018-11-02 06:30:00	QQQ	ETF	172.6	172.61	172.38	172.53	26998.0
2018-11-02 07:00:00	QQQ	ETF	172.49	172.7	172.36	172.7	200215.0
2018-11-02 07:30:00	QQQ	ETF	172.7	172.88	172.62	172.68	97430.0
2018-11-02 08:00:00	QQQ	ETF	172.5699	173.68	171.0	172.24	574638.0
2018-11-02 08:30:00	QQQ	ETF	172.1	172.41	171.7	172.04	556289.0
2018-11-02 09:00:00	QQQ	ETF	171.99	172.17	170.99	171.53	684278.0
2018-11-02 09:30:00	QQQ	ETF	171.53	172.55	170.93	171.345	8330121.0
2018-11-02 10:00:00	QQQ	ETF	171.34	171.45	169.98	169.98	5838755.0
2018-11-02 10:30:00	QQQ	ETF	169.97	170.35	169.2	170.28	5710341.0
2018-11-02 11:00:00	QQQ	ETF	170.295	170.35	169.06	169.53	5299751.0
2018-11-02 11:30:00	QQQ	ETF	169.53	170.0	169.29	169.98	3603608.0
2018-11-02 12:00:00	QQQ	ETF	169.97	170.07	169.39	169.7385	2254335.0
2018-11-02 12:30:00	QQQ	ETF	169.74	169.8572	168.3	168.68	5226128.0

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

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