PREVIEW / etf_30min / 2018-08-14

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-14.parquet
  size:    462 KB
  rows:    15,880

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-08-14 04:00:00	SPY	ETF	283.7	283.7	283.34	283.34	5691.0
2018-08-14 04:30:00	SPY	ETF	283.34	283.34	283.17	283.27	900.0
2018-08-14 05:00:00	SPY	ETF	283.11	283.43	283.11	283.37	3300.0
2018-08-14 05:30:00	SPY	ETF	283.27	283.3	283.22	283.27	1500.0
2018-08-14 06:00:00	SPY	ETF	283.19	283.61	283.19	283.55	11540.0
2018-08-14 06:30:00	SPY	ETF	283.55	283.56	283.4	283.44	94295.0
2018-08-14 07:00:00	SPY	ETF	283.37	283.4	283.23	283.34	127732.0
2018-08-14 07:30:00	SPY	ETF	283.33	283.37	283.15	283.28	26812.0
2018-08-14 08:00:00	SPY	ETF	283.1999	283.36	282.91	283.08	56334.0
2018-08-14 08:30:00	SPY	ETF	283.08	283.23	283.03	283.12	93088.0
2018-08-14 09:00:00	SPY	ETF	283.12	283.12	282.8	282.92	298532.0
2018-08-14 09:30:00	SPY	ETF	282.92	283.33	282.75	282.99	5339671.0
2018-08-14 10:00:00	SPY	ETF	283.0	283.32	282.4833	283.245	3223189.0
2018-08-14 10:30:00	SPY	ETF	283.255	283.9865	283.18	283.7352	3072467.0
2018-08-14 11:00:00	SPY	ETF	283.74	283.91	283.44	283.68	2825873.0
2018-08-14 11:30:00	SPY	ETF	283.69	283.9	283.51	283.5841	2187894.0
2018-08-14 12:00:00	SPY	ETF	283.59	284.0	283.59	283.99	1487793.0
2018-08-14 12:30:00	SPY	ETF	283.99	284.09	283.65	283.67	2298001.0
2018-08-14 13:00:00	SPY	ETF	283.67	283.9	283.63	283.76	1490729.0
2018-08-14 13:30:00	SPY	ETF	283.77	284.07	283.72	284.04	1837838.0
2018-08-14 14:00:00	SPY	ETF	284.05	284.14	283.72	283.86	2174273.0
2018-08-14 14:30:00	SPY	ETF	283.86	284.08	283.84	284.0	1276324.0
2018-08-14 15:00:00	SPY	ETF	284.005	284.17	283.97	284.04	2695197.0
2018-08-14 15:30:00	SPY	ETF	284.05	284.12	283.765	283.86	6758829.0
2018-08-14 16:00:00	SPY	ETF	283.84	283.97	283.66	283.9	4983767.0
2018-08-14 16:30:00	SPY	ETF	283.91	284.04	283.89	283.99	51328.0
2018-08-14 17:00:00	SPY	ETF	283.96	283.97	283.92	283.95	20831.0
2018-08-14 17:30:00	SPY	ETF	283.95	284.05	283.93	283.98	54622.0
2018-08-14 18:00:00	SPY	ETF	284.03	284.03	283.82	283.92	67506.0
2018-08-14 18:30:00	SPY	ETF	283.92	283.97	283.88	283.97	8185.0
2018-08-14 19:00:00	SPY	ETF	283.93	283.95	283.88	283.9	1604.0
2018-08-14 19:30:00	SPY	ETF	283.9	284.0	283.85	283.97	14610.0
2018-08-14 04:00:00	QQQ	ETF	181.4	181.65	181.4	181.44	7434.0
2018-08-14 04:30:00	QQQ	ETF	181.42	181.42	181.26	181.3	4170.0
2018-08-14 05:00:00	QQQ	ETF	181.23	181.52	181.23	181.52	2750.0
2018-08-14 05:30:00	QQQ	ETF	181.4	181.44	181.32	181.39	10500.0
2018-08-14 06:00:00	QQQ	ETF	181.38	181.45	181.34	181.45	5150.0
2018-08-14 06:30:00	QQQ	ETF	181.51	181.52	181.45	181.45	7004.0
2018-08-14 07:00:00	QQQ	ETF	181.34	181.39	181.26	181.34	57185.0
2018-08-14 07:30:00	QQQ	ETF	181.32	181.33	181.18	181.25	41085.0
2018-08-14 08:00:00	QQQ	ETF	181.35	181.35	181.06	181.22	34435.0
2018-08-14 08:30:00	QQQ	ETF	181.16	181.28	181.13	181.13	40281.0
2018-08-14 09:00:00	QQQ	ETF	181.2	181.2	180.96	180.98	135050.0
2018-08-14 09:30:00	QQQ	ETF	181.01	181.2	180.34	180.55	2954958.0
2018-08-14 10:00:00	QQQ	ETF	180.56	180.76	180.04	180.71	1961334.0
2018-08-14 10:30:00	QQQ	ETF	180.72	181.39	180.66	181.25	1616950.0
2018-08-14 11:00:00	QQQ	ETF	181.24	181.41	181.08	181.2501	1368598.0
2018-08-14 11:30:00	QQQ	ETF	181.25	181.57	181.09	181.2964	1144564.0
2018-08-14 12:00:00	QQQ	ETF	181.31	181.66	181.31	181.64	725193.0
2018-08-14 12:30:00	QQQ	ETF	181.64	181.66	181.26	181.335	634292.0

> showing 50 of 15,880 rows — these rows as CSV

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