PREVIEW / etf_30min / 2010-06-16

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-16.parquet
  size:    255 KB
  rows:    8,426

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-06-16 04:00:00	SPY	ETF	111.4	111.54	111.35	111.42	1900.0
2010-06-16 04:30:00	SPY	ETF	111.32	111.44	111.32	111.37	1200.0
2010-06-16 05:00:00	SPY	ETF	111.44	111.44	111.3	111.43	16350.0
2010-06-16 05:30:00	SPY	ETF	111.41	111.55	111.38	111.55	3200.0
2010-06-16 06:00:00	SPY	ETF	111.57	111.6	111.45	111.6	4000.0
2010-06-16 06:30:00	SPY	ETF	111.58	111.58	111.43	111.46	12200.0
2010-06-16 07:00:00	SPY	ETF	111.46	111.53	111.4	111.43	241172.0
2010-06-16 07:30:00	SPY	ETF	111.43	111.44	111.18	111.31	363980.0
2010-06-16 08:00:00	SPY	ETF	111.31	111.42	111.09	111.1	1532590.0
2010-06-16 08:30:00	SPY	ETF	111.1	111.28	110.96	111.21	1806376.0
2010-06-16 09:00:00	SPY	ETF	111.2	111.43	111.15	111.42	2505266.0
2010-06-16 09:30:00	SPY	ETF	111.42	111.75	111.23	111.74	27511183.0
2010-06-16 10:00:00	SPY	ETF	111.75	111.86	111.38	111.45	17559867.0
2010-06-16 10:30:00	SPY	ETF	111.44	111.66	111.2	111.64	11907022.0
2010-06-16 11:00:00	SPY	ETF	111.65	112.02	111.5241	111.93	16586133.0
2010-06-16 11:30:00	SPY	ETF	111.94	112.039	111.745	111.91	10809875.0
2010-06-16 12:00:00	SPY	ETF	111.91	112.3	111.9	112.179	13733958.0
2010-06-16 12:30:00	SPY	ETF	112.17	112.2	111.82	111.94	8020068.0
2010-06-16 13:00:00	SPY	ETF	111.94	112.08	111.82	112.0474	6151538.0
2010-06-16 13:30:00	SPY	ETF	112.05	112.25	111.95	112.2499	5724427.0
2010-06-16 14:00:00	SPY	ETF	112.24	112.42	112.17	112.22	9464244.0
2010-06-16 14:30:00	SPY	ETF	112.21	112.4	112.0	112.1617	12254447.0
2010-06-16 15:00:00	SPY	ETF	112.1631	112.17	111.55	111.59	19889479.0
2010-06-16 15:30:00	SPY	ETF	111.59	112.15	111.51	111.94	28053206.0
2010-06-16 16:00:00	SPY	ETF	111.93	112.1133	110.8021	111.97	10361300.0
2010-06-16 16:30:00	SPY	ETF	111.97	111.97	110.8021	111.8	8693244.0
2010-06-16 17:00:00	SPY	ETF	111.8	111.8	111.67	111.75	210388.0
2010-06-16 17:30:00	SPY	ETF	111.77	111.81	111.75	111.77	2039452.0
2010-06-16 18:00:00	SPY	ETF	111.77	111.96	111.66	111.7	172125.0
2010-06-16 18:30:00	SPY	ETF	111.7	111.75	111.66	111.67	16405.0
2010-06-16 19:00:00	SPY	ETF	111.68	111.68	111.6	111.63	47570.0
2010-06-16 19:30:00	SPY	ETF	111.64	111.66	111.61	111.63	62537.0
2010-06-16 04:00:00	QQQ	ETF	46.43	46.43	46.43	46.43	100.0
2010-06-16 04:30:00	QQQ	ETF	46.47	46.49	46.45	46.48	13900.0
2010-06-16 05:00:00	QQQ	ETF	46.42	46.47	46.42	46.47	600.0
2010-06-16 05:30:00	QQQ	ETF	46.47	46.5	46.46	46.5	13250.0
2010-06-16 06:30:00	QQQ	ETF	46.52	46.52	46.52	46.52	200.0
2010-06-16 07:00:00	QQQ	ETF	46.53	46.54	46.49	46.5	225993.0
2010-06-16 07:30:00	QQQ	ETF	46.5	46.51	46.41	46.49	248272.0
2010-06-16 08:00:00	QQQ	ETF	46.5	46.5	46.37	46.38	726011.0
2010-06-16 08:30:00	QQQ	ETF	46.37	46.44	46.3	46.42	1002576.0
2010-06-16 09:00:00	QQQ	ETF	46.41	46.58	46.4	46.56	696927.0
2010-06-16 09:30:00	QQQ	ETF	46.57	46.78	46.5	46.75	10572182.0
2010-06-16 10:00:00	QQQ	ETF	46.76	46.77	46.5401	46.589	3923705.0
2010-06-16 10:30:00	QQQ	ETF	46.58	46.74	46.5	46.73	4309702.0
2010-06-16 11:00:00	QQQ	ETF	46.73	46.91	46.65	46.8838	8428623.0
2010-06-16 11:30:00	QQQ	ETF	46.88	46.91	46.82	46.88	4260987.0
2010-06-16 12:00:00	QQQ	ETF	46.88	47.03	46.88	46.97	3399622.0
2010-06-16 12:30:00	QQQ	ETF	46.97	46.98	46.82	46.88	2760349.0
2010-06-16 13:00:00	QQQ	ETF	46.89	46.98	46.83	46.96	3353791.0

> showing 50 of 8,426 rows — these rows as CSV

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