PREVIEW / etf_30min / 2018-02-01

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-01.parquet
  size:    494 KB
  rows:    17,081

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-01 04:00:00	SPY	ETF	282.63	282.71	282.45	282.45	1820.0
2018-02-01 04:30:00	SPY	ETF	282.42	282.51	282.38	282.47	3400.0
2018-02-01 05:00:00	SPY	ETF	282.42	282.5	282.4	282.42	2560.0
2018-02-01 05:30:00	SPY	ETF	282.57	282.57	282.27	282.29	10070.0
2018-02-01 06:00:00	SPY	ETF	282.14	282.23	282.03	282.23	3329.0
2018-02-01 06:30:00	SPY	ETF	282.34	282.34	282.08	282.19	59859.0
2018-02-01 07:00:00	SPY	ETF	282.22	282.22	281.89	282.12	76321.0
2018-02-01 07:30:00	SPY	ETF	282.14	282.25	282.0	282.25	156355.0
2018-02-01 08:00:00	SPY	ETF	282.22	282.94	281.39	281.54	479558.0
2018-02-01 08:30:00	SPY	ETF	281.52	281.9	280.75	281.11	998324.0
2018-02-01 09:00:00	SPY	ETF	281.12	281.21	280.37	281.05	1110868.0
2018-02-01 09:30:00	SPY	ETF	281.07	281.92	280.85	281.66	8597442.0
2018-02-01 10:00:00	SPY	ETF	281.66	281.98	281.35	281.48	4410289.0
2018-02-01 10:30:00	SPY	ETF	281.48	281.7355	281.225	281.625	3949118.0
2018-02-01 11:00:00	SPY	ETF	281.62	281.93	281.54	281.65	3373091.0
2018-02-01 11:30:00	SPY	ETF	281.66	282.87	281.64	282.845	5967619.0
2018-02-01 12:00:00	SPY	ETF	282.8554	282.98	282.6	282.68	4366842.0
2018-02-01 12:30:00	SPY	ETF	282.69	282.85	282.61	282.69	1915802.0
2018-02-01 13:00:00	SPY	ETF	282.69	283.06	282.6699	282.92	2749176.0
2018-02-01 13:30:00	SPY	ETF	282.92	282.95	281.91	282.03	3916266.0
2018-02-01 14:00:00	SPY	ETF	282.03	282.16	281.08	281.73	7049332.0
2018-02-01 14:30:00	SPY	ETF	281.73	282.17	281.5	282.13	5456304.0
2018-02-01 15:00:00	SPY	ETF	282.13	282.21	281.31	281.359	5016815.0
2018-02-01 15:30:00	SPY	ETF	281.35	281.74	280.68	281.6	15713407.0
2018-02-01 16:00:00	SPY	ETF	281.59	281.96	281.51	281.8	10233863.0
2018-02-01 16:30:00	SPY	ETF	281.61	281.9191	281.18	281.78	1620425.0
2018-02-01 17:00:00	SPY	ETF	281.74	282.01	281.58	281.94	304355.0
2018-02-01 17:30:00	SPY	ETF	281.95	282.1	281.6515	282.1	1841099.0
2018-02-01 18:00:00	SPY	ETF	282.1	282.47	282.1	282.28	169448.0
2018-02-01 18:30:00	SPY	ETF	282.25	282.25	281.94	282.09	77146.0
2018-02-01 19:00:00	SPY	ETF	282.14	282.21	282.01	282.03	9506.0
2018-02-01 19:30:00	SPY	ETF	282.08	282.08	281.75	281.8	31546.0
2018-02-01 04:00:00	QQQ	ETF	169.55	169.55	169.4	169.4	9200.0
2018-02-01 04:30:00	QQQ	ETF	169.4	169.48	169.39	169.48	2674.0
2018-02-01 05:00:00	QQQ	ETF	169.41	169.47	169.33	169.47	3289.0
2018-02-01 05:30:00	QQQ	ETF	169.52	169.54	169.32	169.32	4300.0
2018-02-01 06:00:00	QQQ	ETF	169.23	169.46	169.23	169.46	10350.0
2018-02-01 06:30:00	QQQ	ETF	169.3	169.3	169.21	169.27	6300.0
2018-02-01 07:00:00	QQQ	ETF	169.24	169.24	168.98	169.13	53436.0
2018-02-01 07:30:00	QQQ	ETF	169.15	169.2	169.08	169.18	71068.0
2018-02-01 08:00:00	QQQ	ETF	169.19	169.84	168.69	168.74	111239.0
2018-02-01 08:30:00	QQQ	ETF	168.73	168.77	167.91	168.16	376328.0
2018-02-01 09:00:00	QQQ	ETF	168.18	168.24	167.78	168.11	354537.0
2018-02-01 09:30:00	QQQ	ETF	168.12	169.14	168.08	168.995	4392993.0
2018-02-01 10:00:00	QQQ	ETF	168.98	169.32	168.83	168.87	2681638.0
2018-02-01 10:30:00	QQQ	ETF	168.86	169.565	168.76	169.43	1635025.0
2018-02-01 11:00:00	QQQ	ETF	169.425	169.555	168.985	169.01	1080766.0
2018-02-01 11:30:00	QQQ	ETF	169.02	169.4999	168.995	169.47	1366239.0
2018-02-01 12:00:00	QQQ	ETF	169.48	169.58	169.24	169.35	1037729.0
2018-02-01 12:30:00	QQQ	ETF	169.366	169.5	169.3298	169.456	801243.0

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

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