PREVIEW / etf_30min / 2010-10-14

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-14.parquet
  size:    271 KB
  rows:    9,045

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
2010-10-14 04:00:00	SPY	ETF	118.01	118.49	118.01	118.39	3300.0
2010-10-14 05:00:00	SPY	ETF	118.28	118.33	118.24	118.24	5100.0
2010-10-14 05:30:00	SPY	ETF	118.1	118.1	118.1	118.1	2575.0
2010-10-14 06:00:00	SPY	ETF	118.18	118.18	118.0	118.0	2500.0
2010-10-14 06:30:00	SPY	ETF	117.97	118.19	117.95	118.13	114700.0
2010-10-14 07:00:00	SPY	ETF	118.14	118.16	118.01	118.11	194485.0
2010-10-14 07:30:00	SPY	ETF	118.15	118.21	118.08	118.09	119598.0
2010-10-14 08:00:00	SPY	ETF	118.08	118.34	118.03	118.33	1081909.0
2010-10-14 08:30:00	SPY	ETF	118.29	118.29	117.93	117.97	2149159.0
2010-10-14 09:00:00	SPY	ETF	117.96	117.97	117.63	117.81	2246267.0
2010-10-14 09:30:00	SPY	ETF	117.8099	117.98	117.43	117.49	29216265.0
2010-10-14 10:00:00	SPY	ETF	117.49	117.89	117.47	117.81	14298195.0
2010-10-14 10:30:00	SPY	ETF	117.81	118.01	117.7	117.9	11180976.0
2010-10-14 11:00:00	SPY	ETF	117.9	117.93	117.55	117.65	9428284.0
2010-10-14 11:30:00	SPY	ETF	117.63	117.71	117.19	117.38	16194436.0
2010-10-14 12:00:00	SPY	ETF	117.38	117.49	117.07	117.1799	10079633.0
2010-10-14 12:30:00	SPY	ETF	117.17	117.34	117.07	117.31	6977982.0
2010-10-14 13:00:00	SPY	ETF	117.31	117.33	116.92	117.05	15151986.0
2010-10-14 13:30:00	SPY	ETF	117.0401	117.36	117.04	117.32	9985600.0
2010-10-14 14:00:00	SPY	ETF	117.313	117.32	117.0	117.0499	8175821.0
2010-10-14 14:30:00	SPY	ETF	117.04	117.08	116.79	116.83	13665881.0
2010-10-14 15:00:00	SPY	ETF	116.83	117.8972	116.72	117.08	18109539.0
2010-10-14 15:30:00	SPY	ETF	117.08	117.52	117.04	117.52	23842725.0
2010-10-14 16:00:00	SPY	ETF	117.52	117.945	116.825	117.87	9788346.0
2010-10-14 16:30:00	SPY	ETF	117.87	118.11	117.81	118.01	2897740.0
2010-10-14 17:00:00	SPY	ETF	118.0	118.03	117.4812	117.96	5076944.0
2010-10-14 17:30:00	SPY	ETF	117.95	118.01	117.91	117.94	100841.0
2010-10-14 18:00:00	SPY	ETF	117.95	118.02	117.55	118.01	214884.0
2010-10-14 18:30:00	SPY	ETF	118.01	118.01	117.97	117.97	7828.0
2010-10-14 19:00:00	SPY	ETF	117.96	117.96	117.8	117.82	66713.0
2010-10-14 19:30:00	SPY	ETF	117.82	117.83	117.71	117.76	150053.0
2010-10-14 04:00:00	QQQ	ETF	50.75	50.75	50.74	50.75	900.0
2010-10-14 04:30:00	QQQ	ETF	50.71	50.71	50.7	50.7	300.0
2010-10-14 05:00:00	QQQ	ETF	50.69	50.69	50.69	50.69	400.0
2010-10-14 06:00:00	QQQ	ETF	50.55	50.61	50.55	50.59	15100.0
2010-10-14 07:00:00	QQQ	ETF	50.61	50.63	50.58	50.63	324690.0
2010-10-14 07:30:00	QQQ	ETF	50.64	50.69	50.63	50.64	322667.0
2010-10-14 08:00:00	QQQ	ETF	50.64	50.69	50.61	50.66	879624.0
2010-10-14 08:30:00	QQQ	ETF	50.66	50.66	50.55	50.6	298635.0
2010-10-14 09:00:00	QQQ	ETF	50.59	50.59	50.45	50.54	271120.0
2010-10-14 09:30:00	QQQ	ETF	50.54	50.59	50.34	50.38	10433088.0
2010-10-14 10:00:00	QQQ	ETF	50.38	50.61	50.37	50.5675	3874665.0
2010-10-14 10:30:00	QQQ	ETF	50.5681	50.64	50.51	50.6	2161224.0
2010-10-14 11:00:00	QQQ	ETF	50.6	50.61	50.46	50.51	2361581.0
2010-10-14 11:30:00	QQQ	ETF	50.51	50.53	50.34	50.41	4640686.0
2010-10-14 12:00:00	QQQ	ETF	50.4101	50.48	50.33	50.36	2630063.0
2010-10-14 12:30:00	QQQ	ETF	50.36	50.44	50.3	50.41	2018608.0
2010-10-14 13:00:00	QQQ	ETF	50.41	50.412	50.23	50.3	3752757.0
2010-10-14 13:30:00	QQQ	ETF	50.3	50.44	50.28	50.41	4167266.0
2010-10-14 14:00:00	QQQ	ETF	50.41	50.42	50.26	50.28	2744743.0

> showing 50 of 9,045 rows — these rows as CSV

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