PREVIEW / etf_30min / 2018-11-13

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-13.parquet
  size:    485 KB
  rows:    16,728

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-13 04:00:00	SPY	ETF	273.91	274.1	273.7	273.85	29246.0
2018-11-13 04:30:00	SPY	ETF	273.9	274.1	273.35	273.35	37837.0
2018-11-13 05:00:00	SPY	ETF	273.35	273.5	273.16	273.45	49173.0
2018-11-13 05:30:00	SPY	ETF	273.27	273.9	273.25	273.9	22701.0
2018-11-13 06:00:00	SPY	ETF	273.95	274.25	273.88	274.15	59509.0
2018-11-13 06:30:00	SPY	ETF	274.24	274.33	274.06	274.1	94535.0
2018-11-13 07:00:00	SPY	ETF	274.1	274.65	274.1	274.26	162075.0
2018-11-13 07:30:00	SPY	ETF	274.35	274.55	273.94	274.04	201864.0
2018-11-13 08:00:00	SPY	ETF	274.05	274.54	273.4	273.86	219023.0
2018-11-13 08:30:00	SPY	ETF	273.71	273.71	273.29	273.57	310203.0
2018-11-13 09:00:00	SPY	ETF	273.56	273.73	272.94	273.07	427363.0
2018-11-13 09:30:00	SPY	ETF	273.09	274.13	273.04	273.28	8767910.0
2018-11-13 10:00:00	SPY	ETF	273.29	273.82	271.92	271.96	8540399.0
2018-11-13 10:30:00	SPY	ETF	271.96	273.52	271.73	273.41	8635167.0
2018-11-13 11:00:00	SPY	ETF	273.38	275.325	273.28	274.54	7566068.0
2018-11-13 11:30:00	SPY	ETF	274.5399	274.76	274.0001	274.24	4163413.0
2018-11-13 12:00:00	SPY	ETF	274.24	274.649	273.71	274.19	3433026.0
2018-11-13 12:30:00	SPY	ETF	274.205	274.22	272.96	273.12	4652673.0
2018-11-13 13:00:00	SPY	ETF	273.12	273.54	272.5401	272.9	4032941.0
2018-11-13 13:30:00	SPY	ETF	272.91	273.86	272.81	273.0911	3898277.0
2018-11-13 14:00:00	SPY	ETF	273.09	273.235	271.47	272.1901	5557730.0
2018-11-13 14:30:00	SPY	ETF	272.2	272.71	271.39	272.05	5967396.0
2018-11-13 15:00:00	SPY	ETF	272.07	272.88	271.36	271.91	7044151.0
2018-11-13 15:30:00	SPY	ETF	271.89	272.67	271.25	272.06	14038445.0
2018-11-13 16:00:00	SPY	ETF	272.04	272.54	271.6	272.41	7783618.0
2018-11-13 16:30:00	SPY	ETF	272.41	272.9	272.0319	272.57	979292.0
2018-11-13 17:00:00	SPY	ETF	272.59	272.66	272.58	272.64	196943.0
2018-11-13 17:30:00	SPY	ETF	272.63	272.85	272.56	272.85	46344.0
2018-11-13 18:00:00	SPY	ETF	272.79	274.1	272.61	273.61	102434.0
2018-11-13 18:30:00	SPY	ETF	273.69	273.7	273.28	273.33	68713.0
2018-11-13 19:00:00	SPY	ETF	273.28	273.7	273.25	273.63	137136.0
2018-11-13 19:30:00	SPY	ETF	273.56	273.56	273.34	273.42	61041.0
2018-11-13 04:00:00	QQQ	ETF	167.69	167.86	167.39	167.66	15685.0
2018-11-13 04:30:00	QQQ	ETF	167.79	167.79	167.24	167.24	26800.0
2018-11-13 05:00:00	QQQ	ETF	167.2	167.3	167.04	167.23	16627.0
2018-11-13 05:30:00	QQQ	ETF	167.21	167.75	167.06	167.75	16401.0
2018-11-13 06:00:00	QQQ	ETF	167.75	167.94	167.66	167.84	37186.0
2018-11-13 06:30:00	QQQ	ETF	167.84	168.01	167.75	167.8	44622.0
2018-11-13 07:00:00	QQQ	ETF	167.83	168.19	167.67	167.76	160704.0
2018-11-13 07:30:00	QQQ	ETF	167.79	168.1	167.58	167.64	157270.0
2018-11-13 08:00:00	QQQ	ETF	167.76	168.15	167.07	167.39	212438.0
2018-11-13 08:30:00	QQQ	ETF	167.32	167.38	167.04	167.23	215634.0
2018-11-13 09:00:00	QQQ	ETF	167.25	167.37	166.93	167.14	196336.0
2018-11-13 09:30:00	QQQ	ETF	167.15	168.48	167.03	167.05	7327091.0
2018-11-13 10:00:00	QQQ	ETF	167.0545	167.8699	166.41	166.6	5871503.0
2018-11-13 10:30:00	QQQ	ETF	166.6	168.19	166.45	168.05	5332867.0
2018-11-13 11:00:00	QQQ	ETF	168.07	169.48	167.99	168.73	7282977.0
2018-11-13 11:30:00	QQQ	ETF	168.74	168.84	168.03	168.1768	2385179.0
2018-11-13 12:00:00	QQQ	ETF	168.19	168.46	167.77	168.12	2439679.0
2018-11-13 12:30:00	QQQ	ETF	168.12	168.14	167.1	167.3538	2459062.0

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

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