PREVIEW / etf_30min / 2018-11-07

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-07.parquet
  size:    509 KB
  rows:    17,405

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-07 04:00:00	SPY	ETF	277.29	277.82	277.29	277.65	58372.0
2018-11-07 04:30:00	SPY	ETF	277.79	278.29	277.71	278.25	39741.0
2018-11-07 05:00:00	SPY	ETF	278.2	278.34	277.9	277.94	42933.0
2018-11-07 05:30:00	SPY	ETF	277.95	278.15	277.92	278.06	24922.0
2018-11-07 06:00:00	SPY	ETF	278.03	278.08	277.75	278.03	37285.0
2018-11-07 06:30:00	SPY	ETF	278.0	278.0	277.51	277.6	201769.0
2018-11-07 07:00:00	SPY	ETF	277.64	278.04	277.6	277.88	282280.0
2018-11-07 07:30:00	SPY	ETF	277.91	277.99	277.21	277.24	253231.0
2018-11-07 08:00:00	SPY	ETF	277.94	278.0101	277.06	277.51	358814.0
2018-11-07 08:30:00	SPY	ETF	277.49	277.75	277.21	277.24	415713.0
2018-11-07 09:00:00	SPY	ETF	277.26	277.63	277.01	277.56	730246.0
2018-11-07 09:30:00	SPY	ETF	277.56	278.4	277.37	277.41	11213567.0
2018-11-07 10:00:00	SPY	ETF	277.4001	278.04	277.08	277.9659	7207515.0
2018-11-07 10:30:00	SPY	ETF	277.96	278.92	277.94	278.56	8370983.0
2018-11-07 11:00:00	SPY	ETF	278.56	278.96	278.36	278.5	5007303.0
2018-11-07 11:30:00	SPY	ETF	278.5	279.43	278.5	279.38	4376712.0
2018-11-07 12:00:00	SPY	ETF	279.39	279.5	279.13	279.13	3512493.0
2018-11-07 12:30:00	SPY	ETF	279.14	279.63	279.09	279.53	3094221.0
2018-11-07 13:00:00	SPY	ETF	279.54	279.76	279.42	279.64	3195891.0
2018-11-07 13:30:00	SPY	ETF	279.64	279.73	279.0	279.24	2959031.0
2018-11-07 14:00:00	SPY	ETF	279.24	280.05	279.21	279.98	4889291.0
2018-11-07 14:30:00	SPY	ETF	279.98	280.41	279.69	280.07	5679545.0
2018-11-07 15:00:00	SPY	ETF	280.07	280.68	280.01	280.64	5198488.0
2018-11-07 15:30:00	SPY	ETF	280.6425	281.1	280.34	280.92	20222390.0
2018-11-07 16:00:00	SPY	ETF	280.92	281.33	280.7378	281.16	11650922.0
2018-11-07 16:30:00	SPY	ETF	281.17	281.33	281.01	281.2599	1509357.0
2018-11-07 17:00:00	SPY	ETF	281.27	281.28	281.12	281.16	141741.0
2018-11-07 17:30:00	SPY	ETF	281.16	281.2	281.01	281.13	56793.0
2018-11-07 18:00:00	SPY	ETF	281.17	281.32	281.1	281.24	78207.0
2018-11-07 18:30:00	SPY	ETF	281.22	281.22	280.97	281.02	117433.0
2018-11-07 19:00:00	SPY	ETF	281.03	281.23	280.98	281.11	24932.0
2018-11-07 19:30:00	SPY	ETF	281.1	281.19	281.01	281.18	26662.0
2018-11-07 04:00:00	QQQ	ETF	172.5	172.92	172.5	172.84	36836.0
2018-11-07 04:30:00	QQQ	ETF	172.89	173.26	172.85	173.22	33716.0
2018-11-07 05:00:00	QQQ	ETF	173.22	173.22	172.87	172.87	18252.0
2018-11-07 05:30:00	QQQ	ETF	172.95	173.03	172.76	172.85	18190.0
2018-11-07 06:00:00	QQQ	ETF	172.82	172.92	172.62	172.85	33400.0
2018-11-07 06:30:00	QQQ	ETF	172.84	172.84	172.48	172.55	36130.0
2018-11-07 07:00:00	QQQ	ETF	172.57	172.95	172.56	172.77	170620.0
2018-11-07 07:30:00	QQQ	ETF	172.77	172.93	172.23	172.25	221077.0
2018-11-07 08:00:00	QQQ	ETF	172.58	172.9499	171.22	172.42	230587.0
2018-11-07 08:30:00	QQQ	ETF	172.42	172.51	172.08	172.12	279866.0
2018-11-07 09:00:00	QQQ	ETF	172.1	172.32	171.73	172.25	323829.0
2018-11-07 09:30:00	QQQ	ETF	172.25	172.995	171.87	172.5	7711410.0
2018-11-07 10:00:00	QQQ	ETF	172.5	173.53	172.4	173.415	4599477.0
2018-11-07 10:30:00	QQQ	ETF	173.42	174.37	173.4147	173.99	4846096.0
2018-11-07 11:00:00	QQQ	ETF	173.99	174.2348	173.7	173.87	2669296.0
2018-11-07 11:30:00	QQQ	ETF	173.88	174.786	173.82	174.73	2414246.0
2018-11-07 12:00:00	QQQ	ETF	174.72	174.76	174.1959	174.25	1807069.0
2018-11-07 12:30:00	QQQ	ETF	174.26	174.74	174.25	174.54	1415747.0

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

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