PREVIEW / etf_30min / 2019-11-15

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-15.parquet
  size:    510 KB
  rows:    17,850

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
2019-11-15 04:00:00	SPY	ETF	310.38	310.64	310.32	310.52	22013.0
2019-11-15 04:30:00	SPY	ETF	310.48	310.6	310.47	310.6	5735.0
2019-11-15 05:00:00	SPY	ETF	310.6	310.6	310.36	310.37	25927.0
2019-11-15 05:30:00	SPY	ETF	310.36	310.41	310.21	310.25	18386.0
2019-11-15 06:00:00	SPY	ETF	310.27	310.3	310.17	310.3	5700.0
2019-11-15 06:30:00	SPY	ETF	310.27	310.35	310.25	310.32	5805.0
2019-11-15 07:00:00	SPY	ETF	310.3	310.5	310.3	310.41	72143.0
2019-11-15 07:30:00	SPY	ETF	310.41	310.59	310.38	310.45	113818.0
2019-11-15 08:00:00	SPY	ETF	310.43	310.67	310.29	310.48	25550.0
2019-11-15 08:30:00	SPY	ETF	310.41	310.7	310.3402	310.67	128240.0
2019-11-15 09:00:00	SPY	ETF	310.67	311.01	310.6	311.01	455771.0
2019-11-15 09:30:00	SPY	ETF	311.02	311.04	310.26	310.31	4751247.0
2019-11-15 10:00:00	SPY	ETF	310.31	310.86	310.29	310.81	6244245.0
2019-11-15 10:30:00	SPY	ETF	310.81	310.94	310.61	310.89	2528599.0
2019-11-15 11:00:00	SPY	ETF	310.89	311.42	310.89	311.38	6885127.0
2019-11-15 11:30:00	SPY	ETF	311.39	311.46	311.15	311.2537	2765926.0
2019-11-15 12:00:00	SPY	ETF	311.25	311.45	311.21	311.26	1716202.0
2019-11-15 12:30:00	SPY	ETF	311.255	311.4	311.195	311.245	1323424.0
2019-11-15 13:00:00	SPY	ETF	311.245	311.29	311.13	311.15	2285480.0
2019-11-15 13:30:00	SPY	ETF	311.1414	311.24	311.08	311.145	1383213.0
2019-11-15 14:00:00	SPY	ETF	311.14	311.43	311.11	311.3325	1779089.0
2019-11-15 14:30:00	SPY	ETF	311.33	311.52	311.21	311.49	1727385.0
2019-11-15 15:00:00	SPY	ETF	311.49	311.58	311.18	311.24	4784167.0
2019-11-15 15:30:00	SPY	ETF	311.24	311.83	311.09	311.83	8718889.0
2019-11-15 16:00:00	SPY	ETF	311.82	311.8902	311.62	311.67	12554358.0
2019-11-15 16:30:00	SPY	ETF	311.67	311.81	311.67	311.81	359597.0
2019-11-15 17:00:00	SPY	ETF	311.8	311.8	311.7	311.79	107736.0
2019-11-15 17:30:00	SPY	ETF	311.71	311.79	311.67	311.73	16039.0
2019-11-15 18:00:00	SPY	ETF	311.73	311.74	311.65	311.74	32244.0
2019-11-15 18:30:00	SPY	ETF	311.74	311.74	311.66	311.71	653498.0
2019-11-15 19:00:00	SPY	ETF	311.66	311.76	311.66	311.72	10423.0
2019-11-15 19:30:00	SPY	ETF	311.7	311.77	311.68	311.68	16420.0
2019-11-15 04:00:00	QQQ	ETF	202.02	202.23	201.99	202.15	24537.0
2019-11-15 04:30:00	QQQ	ETF	202.16	202.25	202.14	202.25	7540.0
2019-11-15 05:00:00	QQQ	ETF	202.28	202.28	202.07	202.08	17430.0
2019-11-15 05:30:00	QQQ	ETF	202.09	202.11	201.96	201.97	17000.0
2019-11-15 06:00:00	QQQ	ETF	201.99	202.05	201.92	202.01	9500.0
2019-11-15 06:30:00	QQQ	ETF	202.01	202.1	201.98	202.07	7350.0
2019-11-15 07:00:00	QQQ	ETF	202.08	202.23	202.05	202.18	34389.0
2019-11-15 07:30:00	QQQ	ETF	202.19	202.31	202.18	202.21	64594.0
2019-11-15 08:00:00	QQQ	ETF	202.1601	202.3	201.43	202.25	36870.0
2019-11-15 08:30:00	QQQ	ETF	202.29	202.54	202.2299	202.53	48286.0
2019-11-15 09:00:00	QQQ	ETF	202.51	202.76	202.41	202.62	152533.0
2019-11-15 09:30:00	QQQ	ETF	202.62	202.68	202.0	202.02	1699942.0
2019-11-15 10:00:00	QQQ	ETF	202.015	202.58	202.01	202.51	1290258.0
2019-11-15 10:30:00	QQQ	ETF	202.51	202.5553	202.33	202.51	556159.0
2019-11-15 11:00:00	QQQ	ETF	202.52	202.805	202.515	202.72	957382.0
2019-11-15 11:30:00	QQQ	ETF	202.73	202.74	202.4119	202.5065	832718.0
2019-11-15 12:00:00	QQQ	ETF	202.51	202.64	202.4	202.4264	469201.0
2019-11-15 12:30:00	QQQ	ETF	202.42	202.65	202.4064	202.58	613621.0

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

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