PREVIEW / etf_30min / 2008-10-17

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-17.parquet
  size:    181 KB
  rows:    6,550

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
2008-10-17 04:00:00	SPY	ETF	92.73	92.73	92.44	92.44	500.0
2008-10-17 04:30:00	SPY	ETF	92.64	92.64	92.03	92.03	500.0
2008-10-17 05:00:00	SPY	ETF	92.35	92.35	91.65	91.65	9700.0
2008-10-17 05:30:00	SPY	ETF	91.35	91.55	91.0	91.0	63100.0
2008-10-17 06:00:00	SPY	ETF	91.22	92.34	91.2	91.41	225600.0
2008-10-17 06:30:00	SPY	ETF	91.54	92.68	91.46	92.25	275722.0
2008-10-17 07:00:00	SPY	ETF	92.25	92.89	92.15	92.87	609993.0
2008-10-17 07:30:00	SPY	ETF	92.85	93.27	92.51	93.27	1128292.0
2008-10-17 08:00:00	SPY	ETF	92.4	94.25	91.9	93.0	2568522.0
2008-10-17 08:30:00	SPY	ETF	92.85	93.2	92.27	92.7	5202419.0
2008-10-17 09:00:00	SPY	ETF	92.7	92.71	91.55	92.0	4516855.0
2008-10-17 09:30:00	SPY	ETF	91.99	94.22	91.65	94.17	55256635.0
2008-10-17 10:00:00	SPY	ETF	94.16	94.63	93.17	94.32	37783753.0
2008-10-17 10:30:00	SPY	ETF	94.32	95.28	93.38	94.79	35311469.0
2008-10-17 11:00:00	SPY	ETF	94.78	95.64	94.11	94.24	27648639.0
2008-10-17 11:30:00	SPY	ETF	94.23	94.65	93.9	94.49	19587529.0
2008-10-17 12:00:00	SPY	ETF	94.49	95.34	94.44	95.17	14758548.0
2008-10-17 12:30:00	SPY	ETF	95.18	96.8	94.5	96.64	20291408.0
2008-10-17 13:00:00	SPY	ETF	96.63	97.42	96.4	97.2201	27267416.0
2008-10-17 13:30:00	SPY	ETF	97.2201	98.59	96.1	97.4425	34821729.0
2008-10-17 14:00:00	SPY	ETF	97.63	98.18	95.0	96.38	30686392.0
2008-10-17 14:30:00	SPY	ETF	96.39	97.0	95.07	96.3	35344251.0
2008-10-17 15:00:00	SPY	ETF	96.3	97.09	94.12	95.13	45401067.0
2008-10-17 15:30:00	SPY	ETF	95.13	95.79	93.7	94.07	52982111.0
2008-10-17 16:00:00	SPY	ETF	94.09	97.75	93.0	93.08	15427727.0
2008-10-17 16:30:00	SPY	ETF	93.05	93.35	92.98	93.34	6874851.0
2008-10-17 17:00:00	SPY	ETF	93.35	93.45	93.21	93.41	481858.0
2008-10-17 17:30:00	SPY	ETF	93.4	93.7	93.33	93.68	349403.0
2008-10-17 18:00:00	SPY	ETF	93.7	93.84	93.6	93.7	115566.0
2008-10-17 18:30:00	SPY	ETF	93.7	93.7	93.29	93.4	19983.0
2008-10-17 19:00:00	SPY	ETF	93.36	93.44	93.3	93.44	7068.0
2008-10-17 19:30:00	SPY	ETF	93.47	93.5	93.35	93.5	11469.0
2008-10-17 04:00:00	QQQ	ETF	31.97	31.97	31.85	31.85	2320.0
2008-10-17 04:30:00	QQQ	ETF	31.94	31.94	31.94	31.94	100.0
2008-10-17 05:00:00	QQQ	ETF	31.79	31.79	31.61	31.61	300.0
2008-10-17 05:30:00	QQQ	ETF	31.52	31.52	31.25	31.25	1600.0
2008-10-17 06:00:00	QQQ	ETF	31.28	31.6	31.25	31.52	500.0
2008-10-17 06:30:00	QQQ	ETF	31.55	31.88	31.55	31.73	52730.0
2008-10-17 07:00:00	QQQ	ETF	31.75	31.97	31.75	31.97	60679.0
2008-10-17 07:30:00	QQQ	ETF	31.99	32.03	31.76	32.03	231877.0
2008-10-17 08:00:00	QQQ	ETF	32.02	32.19	31.75	31.79	1199776.0
2008-10-17 08:30:00	QQQ	ETF	31.78	32.07	31.66	31.82	1332916.0
2008-10-17 09:00:00	QQQ	ETF	31.81	31.88	31.5	31.61	3484000.0
2008-10-17 09:30:00	QQQ	ETF	31.62	32.33	31.41	32.3101	39680234.0
2008-10-17 10:00:00	QQQ	ETF	32.32	32.4	31.82	32.24	28838051.0
2008-10-17 10:30:00	QQQ	ETF	32.23	32.63	31.93	32.49	23489175.0
2008-10-17 11:00:00	QQQ	ETF	32.5	32.79	32.33	32.37	19715401.0
2008-10-17 11:30:00	QQQ	ETF	32.36	32.47	32.2	32.32	10720158.0
2008-10-17 12:00:00	QQQ	ETF	32.32	32.69	32.28	32.62	11062179.0
2008-10-17 12:30:00	QQQ	ETF	32.62	33.05	32.48	33.01	13127617.0

> showing 50 of 6,550 rows — these rows as CSV

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