PREVIEW / etf_30min / 2009-02-10

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-10.parquet
  size:    209 KB
  rows:    6,815

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
2009-02-10 04:00:00	SPY	ETF	85.87	85.93	85.83	85.93	2600.0
2009-02-10 04:30:00	SPY	ETF	85.93	85.93	85.8	85.8	2800.0
2009-02-10 05:00:00	SPY	ETF	85.91	85.91	85.9	85.9	600.0
2009-02-10 05:30:00	SPY	ETF	85.96	86.06	85.94	85.99	6500.0
2009-02-10 06:00:00	SPY	ETF	85.98	86.01	85.96	85.99	3400.0
2009-02-10 06:30:00	SPY	ETF	85.95	86.24	85.95	86.15	37100.0
2009-02-10 07:00:00	SPY	ETF	86.14	86.7	86.08	86.46	265972.0
2009-02-10 07:30:00	SPY	ETF	86.48	86.78	86.43	86.72	468177.0
2009-02-10 08:00:00	SPY	ETF	86.71	86.72	85.63	86.58	1851815.0
2009-02-10 08:30:00	SPY	ETF	86.58	86.76	86.05	86.11	1740470.0
2009-02-10 09:00:00	SPY	ETF	86.11	86.4	86.05	86.28	3689520.0
2009-02-10 09:30:00	SPY	ETF	86.27	87.03	86.17	86.62	24204915.0
2009-02-10 10:00:00	SPY	ETF	86.62	86.83	85.78	85.85	26019176.0
2009-02-10 10:30:00	SPY	ETF	85.86	86.22	85.82	86.15	19991909.0
2009-02-10 11:00:00	SPY	ETF	86.14	86.7	84.74	85.15	76074801.0
2009-02-10 11:30:00	SPY	ETF	85.15	85.18	83.66	84.18	69985120.0
2009-02-10 12:00:00	SPY	ETF	84.19	84.4	83.93	84.08	24945669.0
2009-02-10 12:30:00	SPY	ETF	84.08	84.49	83.87	84.31	25282047.0
2009-02-10 13:00:00	SPY	ETF	84.31	84.33	83.12	83.37	34535362.0
2009-02-10 13:30:00	SPY	ETF	83.3699	83.71	83.26	83.4192	25809273.0
2009-02-10 14:00:00	SPY	ETF	83.41	83.69	83.02	83.04	22256050.0
2009-02-10 14:30:00	SPY	ETF	83.04	83.34	82.77	82.84	27565503.0
2009-02-10 15:00:00	SPY	ETF	82.84	83.3	82.54	82.85	39226998.0
2009-02-10 15:30:00	SPY	ETF	82.8588	84.8	82.45	82.96	64294003.0
2009-02-10 16:00:00	SPY	ETF	82.97	87.1818	82.73	83.05	11162691.0
2009-02-10 16:30:00	SPY	ETF	83.06	83.17	82.9811	83.14	15704088.0
2009-02-10 17:00:00	SPY	ETF	83.12	87.1795	83.1	83.14	19710212.0
2009-02-10 17:30:00	SPY	ETF	83.12	83.2	83.11	83.18	64794.0
2009-02-10 18:00:00	SPY	ETF	83.17	83.4	83.16	83.28	76171.0
2009-02-10 18:30:00	SPY	ETF	83.27	83.39	83.27	83.36	48020.0
2009-02-10 19:00:00	SPY	ETF	83.35	83.55	83.32	83.53	74692.0
2009-02-10 19:30:00	SPY	ETF	83.53	83.6	83.4	83.45	73480.0
2009-02-10 04:00:00	QQQ	ETF	31.12	31.12	31.12	31.12	320.0
2009-02-10 04:30:00	QQQ	ETF	31.16	31.16	31.16	31.16	773.0
2009-02-10 05:00:00	QQQ	ETF	31.14	31.14	31.14	31.14	300.0
2009-02-10 06:30:00	QQQ	ETF	31.18	31.22	31.18	31.22	1193.0
2009-02-10 07:00:00	QQQ	ETF	31.26	31.39	31.26	31.39	19826.0
2009-02-10 07:30:00	QQQ	ETF	31.35	31.45	31.35	31.41	72550.0
2009-02-10 08:00:00	QQQ	ETF	31.4	31.43	31.34	31.36	149498.0
2009-02-10 08:30:00	QQQ	ETF	31.35	31.43	31.17	31.17	866780.0
2009-02-10 09:00:00	QQQ	ETF	31.17	31.32	31.16	31.3	882579.0
2009-02-10 09:30:00	QQQ	ETF	31.3	31.68	31.27	31.53	14055106.0
2009-02-10 10:00:00	QQQ	ETF	31.54	31.6	31.19	31.221	15352398.0
2009-02-10 10:30:00	QQQ	ETF	31.22	31.37	31.21	31.24	11953498.0
2009-02-10 11:00:00	QQQ	ETF	31.24	31.34	30.77	30.95	45673929.0
2009-02-10 11:30:00	QQQ	ETF	30.95	30.96	30.36	30.62	31641056.0
2009-02-10 12:00:00	QQQ	ETF	30.63	30.7899	30.56	30.65	10777507.0
2009-02-10 12:30:00	QQQ	ETF	30.65	30.74	30.53	30.68	7979028.0
2009-02-10 13:00:00	QQQ	ETF	30.68	30.69	30.29	30.33	11425548.0
2009-02-10 13:30:00	QQQ	ETF	30.33	30.46	30.3	30.3711	6553194.0

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

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