PREVIEW / etf_30min / 2018-11-06

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-06.parquet
  size:    474 KB
  rows:    16,459

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-06 04:00:00	SPY	ETF	273.24	273.48	273.24	273.33	11359.0
2018-11-06 04:30:00	SPY	ETF	273.31	273.34	272.88	272.92	16900.0
2018-11-06 05:00:00	SPY	ETF	272.81	273.22	272.67	272.8	32831.0
2018-11-06 05:30:00	SPY	ETF	272.9	273.14	272.71	272.75	31569.0
2018-11-06 06:00:00	SPY	ETF	272.83	273.25	272.83	273.2	18609.0
2018-11-06 06:30:00	SPY	ETF	273.15	273.2	273.01	273.03	10721.0
2018-11-06 07:00:00	SPY	ETF	273.02	273.15	272.83	273.13	67881.0
2018-11-06 07:30:00	SPY	ETF	273.12	273.24	272.98	273.16	58917.0
2018-11-06 08:00:00	SPY	ETF	273.06	273.92	272.86	272.9	136282.0
2018-11-06 08:30:00	SPY	ETF	272.91	273.17	272.84	272.99	154502.0
2018-11-06 09:00:00	SPY	ETF	273.02	273.37	273.02	273.32	193234.0
2018-11-06 09:30:00	SPY	ETF	273.32	274.82	273.25	274.6	5656419.0
2018-11-06 10:00:00	SPY	ETF	274.59	274.6601	274.17	274.28	3304507.0
2018-11-06 10:30:00	SPY	ETF	274.26	274.5481	273.86	274.39	2698486.0
2018-11-06 11:00:00	SPY	ETF	274.4	274.76	274.03	274.21	2669040.0
2018-11-06 11:30:00	SPY	ETF	274.22	274.53	273.92	274.39	2548885.0
2018-11-06 12:00:00	SPY	ETF	274.42	274.73	274.25	274.54	2187635.0
2018-11-06 12:30:00	SPY	ETF	274.55	274.99	274.5	274.71	2157211.0
2018-11-06 13:00:00	SPY	ETF	274.72	274.91	274.6	274.6001	1835087.0
2018-11-06 13:30:00	SPY	ETF	274.6077	274.82	274.525	274.72	1833018.0
2018-11-06 14:00:00	SPY	ETF	274.71	274.74	273.47	273.62	4516084.0
2018-11-06 14:30:00	SPY	ETF	273.62	274.18	273.45	273.96	4098830.0
2018-11-06 15:00:00	SPY	ETF	273.96	274.58	273.74	274.37	3857020.0
2018-11-06 15:30:00	SPY	ETF	274.38	275.3	274.0	275.11	12292721.0
2018-11-06 16:00:00	SPY	ETF	275.1	275.71	274.2867	275.47	7593478.0
2018-11-06 16:30:00	SPY	ETF	275.47	275.59	275.12	275.42	288234.0
2018-11-06 17:00:00	SPY	ETF	275.42	275.53	275.35	275.4018	181030.0
2018-11-06 17:30:00	SPY	ETF	275.41	275.46	275.35	275.35	77614.0
2018-11-06 18:00:00	SPY	ETF	275.35	275.55	274.91	275.14	789716.0
2018-11-06 18:30:00	SPY	ETF	275.1	275.1	274.75	274.97	32796.0
2018-11-06 19:00:00	SPY	ETF	274.96	275.3	274.81	275.2	52194.0
2018-11-06 19:30:00	SPY	ETF	275.26	275.49	274.19	275.0	155998.0
2018-11-06 04:00:00	QQQ	ETF	168.79	168.93	168.66	168.9	6739.0
2018-11-06 04:30:00	QQQ	ETF	168.73	168.73	168.26	168.32	10328.0
2018-11-06 05:00:00	QQQ	ETF	168.3	168.57	168.15	168.33	9388.0
2018-11-06 05:30:00	QQQ	ETF	168.42	168.58	168.2	168.29	11674.0
2018-11-06 06:00:00	QQQ	ETF	168.32	168.7	168.32	168.65	18436.0
2018-11-06 06:30:00	QQQ	ETF	168.61	168.78	168.56	168.65	8185.0
2018-11-06 07:00:00	QQQ	ETF	168.65	168.69	168.41	168.67	17788.0
2018-11-06 07:30:00	QQQ	ETF	168.55	168.78	168.53	168.74	15771.0
2018-11-06 08:00:00	QQQ	ETF	168.55	169.39	168.49	168.49	38031.0
2018-11-06 08:30:00	QQQ	ETF	168.49	168.72	168.49	168.59	92222.0
2018-11-06 09:00:00	QQQ	ETF	168.59	168.93	168.59	168.93	116952.0
2018-11-06 09:30:00	QQQ	ETF	168.93	171.19	168.9	170.86	5622060.0
2018-11-06 10:00:00	QQQ	ETF	170.84	170.9	170.37	170.49	2017980.0
2018-11-06 10:30:00	QQQ	ETF	170.5	170.72	169.77	169.87	2119199.0
2018-11-06 11:00:00	QQQ	ETF	169.88	170.2523	169.43	169.67	2219584.0
2018-11-06 11:30:00	QQQ	ETF	169.68	170.09	169.35	169.93	1456825.0
2018-11-06 12:00:00	QQQ	ETF	169.94	170.32	169.81	170.1	931831.0
2018-11-06 12:30:00	QQQ	ETF	170.12	170.49	170.08	170.14	1007823.0

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

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