PREVIEW / etf_30min / 2018-08-03

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-03.parquet
  size:    451 KB
  rows:    15,595

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-03 04:00:00	SPY	ETF	282.3	282.33	282.12	282.33	7704.0
2018-08-03 04:30:00	SPY	ETF	282.31	282.38	282.28	282.34	2123.0
2018-08-03 05:00:00	SPY	ETF	282.32	282.35	282.27	282.32	3500.0
2018-08-03 05:30:00	SPY	ETF	282.4	282.51	282.4	282.51	2905.0
2018-08-03 06:00:00	SPY	ETF	282.65	282.67	282.57	282.57	9100.0
2018-08-03 06:30:00	SPY	ETF	282.54	282.65	282.53	282.65	4712.0
2018-08-03 07:00:00	SPY	ETF	282.62	283.18	282.62	283.12	46208.0
2018-08-03 07:30:00	SPY	ETF	283.14	283.25	282.91	282.91	42442.0
2018-08-03 08:00:00	SPY	ETF	283.1799	283.25	282.42	282.84	263638.0
2018-08-03 08:30:00	SPY	ETF	282.75	282.91	282.39	282.42	386630.0
2018-08-03 09:00:00	SPY	ETF	282.44	282.76	282.42	282.55	279635.0
2018-08-03 09:30:00	SPY	ETF	282.53	282.76	282.33	282.53	4909877.0
2018-08-03 10:00:00	SPY	ETF	282.51	283.15	282.44	283.0643	3043324.0
2018-08-03 10:30:00	SPY	ETF	283.0658	283.19	282.66	282.73	3159129.0
2018-08-03 11:00:00	SPY	ETF	282.74	282.99	282.61	282.84	2175468.0
2018-08-03 11:30:00	SPY	ETF	282.84	282.88	282.505	282.51	1921541.0
2018-08-03 12:00:00	SPY	ETF	282.51	283.055	282.4901	283.03	1530858.0
2018-08-03 12:30:00	SPY	ETF	283.02	283.07	282.895	282.98	1456613.0
2018-08-03 13:00:00	SPY	ETF	282.98	283.199	282.98	283.13	1592951.0
2018-08-03 13:30:00	SPY	ETF	283.13	283.32	283.01	283.285	2413993.0
2018-08-03 14:00:00	SPY	ETF	283.28	283.32	283.15	283.255	2112224.0
2018-08-03 14:30:00	SPY	ETF	283.255	283.35	283.19	283.335	2462470.0
2018-08-03 15:00:00	SPY	ETF	283.335	283.65	283.3	283.43	5294988.0
2018-08-03 15:30:00	SPY	ETF	283.44	283.65	283.3615	283.64	8461976.0
2018-08-03 16:00:00	SPY	ETF	283.65	283.6661	283.4733	283.65	10221506.0
2018-08-03 16:30:00	SPY	ETF	283.62	283.74	283.58	283.7	994767.0
2018-08-03 17:00:00	SPY	ETF	283.73	283.73	283.61	283.61	34236.0
2018-08-03 17:30:00	SPY	ETF	283.61	283.69	283.59	283.61	19373.0
2018-08-03 18:00:00	SPY	ETF	283.6	283.69	283.6	283.69	5389.0
2018-08-03 18:30:00	SPY	ETF	283.67	283.67	283.64	283.64	750.0
2018-08-03 19:00:00	SPY	ETF	283.65	283.65	283.61	283.64	6171.0
2018-08-03 19:30:00	SPY	ETF	283.64	283.66	283.62	283.62	6820.0
2018-08-03 04:00:00	QQQ	ETF	179.57	179.67	179.54	179.66	2800.0
2018-08-03 04:30:00	QQQ	ETF	179.66	179.67	179.63	179.65	4690.0
2018-08-03 05:00:00	QQQ	ETF	179.64	179.64	179.61	179.64	2900.0
2018-08-03 05:30:00	QQQ	ETF	179.71	179.82	179.71	179.82	5100.0
2018-08-03 06:00:00	QQQ	ETF	179.8	179.9	179.8	179.84	3350.0
2018-08-03 06:30:00	QQQ	ETF	179.8	179.88	179.77	179.84	3273.0
2018-08-03 07:00:00	QQQ	ETF	179.84	180.18	179.83	180.18	38227.0
2018-08-03 07:30:00	QQQ	ETF	180.17	180.36	180.17	180.22	38709.0
2018-08-03 08:00:00	QQQ	ETF	179.88	180.3499	179.53	179.92	112672.0
2018-08-03 08:30:00	QQQ	ETF	179.74	180.2	179.59	179.64	156623.0
2018-08-03 09:00:00	QQQ	ETF	179.65	180.01	179.5701	179.74	92891.0
2018-08-03 09:30:00	QQQ	ETF	179.79	179.99	179.08	179.45	5160753.0
2018-08-03 10:00:00	QQQ	ETF	179.45	180.09	179.37	180.02	2629545.0
2018-08-03 10:30:00	QQQ	ETF	180.01	180.03	179.39	179.53	1837410.0
2018-08-03 11:00:00	QQQ	ETF	179.51	179.82	179.34	179.65	1424264.0
2018-08-03 11:30:00	QQQ	ETF	179.66	179.66	179.26	179.26	921710.0
2018-08-03 12:00:00	QQQ	ETF	179.26	179.71	179.26	179.65	1208831.0
2018-08-03 12:30:00	QQQ	ETF	179.655	179.78	179.49	179.6565	850743.0

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

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