PREVIEW / etf_1hour / 2018-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-10.parquet
  size:    336 KB
  rows:    10,933

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-10-10 04:00:00	SPY	ETF	287.45	287.54	287.21	287.31	5019.0
2018-10-10 05:00:00	SPY	ETF	287.26	287.49	287.23	287.26	11840.0
2018-10-10 06:00:00	SPY	ETF	287.34	287.74	287.34	287.63	21450.0
2018-10-10 07:00:00	SPY	ETF	287.59	287.8	287.12	287.16	178424.0
2018-10-10 08:00:00	SPY	ETF	287.4	288.01	286.44	286.7	932112.0
2018-10-10 09:00:00	SPY	ETF	286.73	286.91	284.59	284.72	14751801.0
2018-10-10 10:00:00	SPY	ETF	284.735	285.05	283.95	284.26	26370892.0
2018-10-10 11:00:00	SPY	ETF	284.27	284.36	282.69	283.12	25095739.0
2018-10-10 12:00:00	SPY	ETF	283.11	283.88	282.74	283.03	16542467.0
2018-10-10 13:00:00	SPY	ETF	283.03	283.8	282.31	282.85	13174939.0
2018-10-10 14:00:00	SPY	ETF	282.84	282.95	281.05	281.63	21860510.0
2018-10-10 15:00:00	SPY	ETF	281.63	281.635	277.88	278.17	61921336.0
2018-10-10 16:00:00	SPY	ETF	278.17	287.4002	276.22	276.24	25213890.0
2018-10-10 17:00:00	SPY	ETF	276.28	282.389	276.13	276.52	4360401.0
2018-10-10 18:00:00	SPY	ETF	276.6	278.3	276.25	277.01	369520.0
2018-10-10 19:00:00	SPY	ETF	277.03	277.45	276.4	276.7	239690.0
2018-10-10 04:00:00	QQQ	ETF	179.49	179.53	179.2	179.33	73165.0
2018-10-10 05:00:00	QQQ	ETF	179.21	179.38	179.16	179.28	3600.0
2018-10-10 06:00:00	QQQ	ETF	179.33	179.52	179.32	179.36	221999.0
2018-10-10 07:00:00	QQQ	ETF	179.36	179.53	178.8	178.87	216830.0
2018-10-10 08:00:00	QQQ	ETF	178.88	179.87	178.37	178.55	618421.0
2018-10-10 09:00:00	QQQ	ETF	178.53	178.67	175.94	176.22	12815649.0
2018-10-10 10:00:00	QQQ	ETF	176.23	176.79	175.579	176.2366	15500648.0
2018-10-10 11:00:00	QQQ	ETF	176.2499	176.3799	174.85	175.39	11127013.0
2018-10-10 12:00:00	QQQ	ETF	175.35	176.14	174.925	175.3335	7459875.0
2018-10-10 13:00:00	QQQ	ETF	175.34	176.34	174.88	175.57	8252367.0
2018-10-10 14:00:00	QQQ	ETF	175.56	175.6699	174.1	174.64	11497499.0
2018-10-10 15:00:00	QQQ	ETF	174.63	174.63	171.5	171.73	26486620.0
2018-10-10 16:00:00	QQQ	ETF	171.73	175.7254	170.0	170.06	4282061.0
2018-10-10 17:00:00	QQQ	ETF	170.01	171.73	169.99	170.35	422407.0
2018-10-10 18:00:00	QQQ	ETF	170.34	171.17	170.2	170.68	831535.0
2018-10-10 19:00:00	QQQ	ETF	170.72	171.05	170.13	170.42	156729.0
2018-10-10 04:00:00	IWM	ETF	161.11	161.11	161.11	161.11	100.0
2018-10-10 05:00:00	IWM	ETF	161.03	161.15	161.03	161.1	2350.0
2018-10-10 06:00:00	IWM	ETF	161.1	161.4	161.1	161.35	5693.0
2018-10-10 07:00:00	IWM	ETF	161.3	161.42	160.9	160.9	57296.0
2018-10-10 08:00:00	IWM	ETF	161.1	161.19	160.5	160.62	58189.0
2018-10-10 09:00:00	IWM	ETF	160.62	160.9865	159.61	159.68	3929039.0
2018-10-10 10:00:00	IWM	ETF	159.69	160.31	159.33	159.64	5174775.0
2018-10-10 11:00:00	IWM	ETF	159.63	159.665	158.6	159.195	5873468.0
2018-10-10 12:00:00	IWM	ETF	159.19	159.395	158.53	158.79	3253351.0
2018-10-10 13:00:00	IWM	ETF	158.77	159.69	158.4	159.4	3702316.0
2018-10-10 14:00:00	IWM	ETF	159.37	159.4	157.99	158.41	4141063.0
2018-10-10 15:00:00	IWM	ETF	158.4	158.41	156.36	156.66	11199182.0
2018-10-10 16:00:00	IWM	ETF	156.65	156.75	155.37	155.39	2110281.0
2018-10-10 17:00:00	IWM	ETF	155.42	156.56	155.3	155.49	1737615.0
2018-10-10 18:00:00	IWM	ETF	155.54	155.72	155.35	155.72	46020.0
2018-10-10 19:00:00	IWM	ETF	155.74	155.89	155.55	155.58	10077.0
2018-10-10 08:00:00	DIA	ETF	264.36	264.51	263.64	263.71	26321.0
2018-10-10 09:00:00	DIA	ETF	263.77	264.12	262.08	262.26	1339679.0

> showing 50 of 10,933 rows — these rows as CSV

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